Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “retotalling” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
retotalling124404(None) 
retotaling1186881retota_ling
rototilling1252642rototilling
teetotalling1351862teetotalling
totalling1036522__totalling
metalling1249593me__talling
rebottling1343733rebot_tling
recalling122211903re__calling
recoaling121312453reco_a_ling
redialling1246203re_dialling
refalling132010423re__falling
reinstalling1373393reinstalling
remodelling1542783remodelling
repolling122110203repo__lling
rerolling102210373rero__lling
restabling1337653re_stabling
retailing103214733re__tailing
retallying1464703re__tallying
retelling102112493re__telling
retitling1039773retit__ling
retooling1039093reto__oling
retotalled1143623retotall_ed
subtotalling1551813subtotalling
teetotaling1252533teetota_ling
totaling9610303__tota_ling
befalling15226504be__falling
begalling13216494be__galling
catcalling1545124cat_calling
detailing112510414de__tailing
detonating1248824detona_ting
entailing1039394_e_ntailing
enthralling1543844enthralling
equalling1945244_e_qualling
extolling1744624_e_xtolling
eyeballing1642264_eyeballing
fettling1266774fet_t__ling
forestalling1653634fore_stalling
installing1146404_installing
inthralling1544114inthralling
lateralling1244634lateralling
medalling1346924me__dalling
metaling111613724me__ta_ling
metalline1158734me__talline
mothballing1952314mothballing
nettling957214net_t__ling
outtalking1545484out_talking
outtelling11107134out_telling
pedalling1346664pe__dalling
pedestalling1652564pedestalling
peptalking1943254pe_ptalking
pettling1168214pet_t__ling
pretelling1338134pre__telling
protocolling1753024protocolling
rattling92510874rat_t__ling
reassailing1244104reassailing
reattaching1743124reattaching
reattacking1843304reattacking
reattaining1244594reattaining
reavailing1444874re_availing
rebelling122111164re__belling
rebilling12228834re__billing
reboarding1445674rebo_arding
reboiling12149824rebo__iling
recataloging1651724recataloging
recoating121317464reco_a_ting
recoiling121412414reco__iling
recompiling1843994recompiling
reconciling1645484reconciling
reconsoling1444484reconsoling
recontacting1745064recontacting
recoupling1545044reco_upling
redialing11311844re_dia_ling
redistilling1453304redistilling
redoubling1443434redo_ubling
redrilling1246074re_drilling
reenrolling1242704reenrolling
reexpelling2142524reexpelling
refelling132211314re__felling
refilling13299334re__filling
refolding1437454refo__lding
refuelling1474974re_fuelling
regaling10315364re__ga_ling
relabelling1442664relabelling
reloading1189884relo_a_ding
reloaning10710484relo_a_ning
relocating13310874reloca_ting
remailing122412474re__mailing
remodeling1445024remo_deling
remolding1338164remo__lding
renailing102813334re__nailing
renotifying1844184renotifying
renovating1447424renova_ting
reobtaining1443534reobtaining
reoiling93217214re_o__iling
repanelling1443474repanelling
repealing122513544re_pea_ling
repelling122312754re__pelling
repotting12511124repot__ting
resailing103314254re__sailing
rescaling122212014re_sca_ling
resealing102115674re_sea_ling
reselling102213834re__selling
resettling1135894reset_tling
resoaking1439374reso_a_king
resoling92916304reso___ling
resolving1337744reso__lving
resonating11311264resona_ting
respelling1347974re_spelling
restacking1737184re_stacking
restaffing1744194re_staffing
restaging112410854re_sta_ging
restamping1565214re_stamping
restarting11310664re_starting
restating102319414re_sta_ting
restyling1337924re_st_yling
retacking1658974re__tacking
retackling1744434ret_ackling
retagging1236034re__tagging
retailings11265234re__tailings
retaining102114734re__taining
retaking133114284re__ta_king
retallied1046784re__tallied
retallies939374re__tallies
retaping113012554re__ta_ping
retarding111110654re__tarding
retasting102513414re__tasting
retaxing162311334re__ta_xing
reteaching1636024ret_eaching
reteaming122110444ret_ea_ming
retearing102214254ret_ea_ring
retellings11244654re__tellings
retiling93319484re__t_iling
retorting10613274reto__rting
retotal739844retota_l___
retotaled1045954retota_l_ed
retotals838464retota_l__s
retouching1644694reto_uching
retracing12313294ret_ra_cing
retracking1738164ret_racking
retracting13311934ret_racting
retraining11310244ret_raining
retreading12128484retrea_ding
retreating111414774retrea_ting
retroacting1447284retroacting
retting83425884ret_t___ing
revaluing1337304re__valuing
revealing132611884re_vea_ling
revelling132412554re__velling
revictualling1961144revictualling
revitalising1654664revitalising
revitalizing2546624revitalizing
revolting1339634revo__lting
revolving1635844revo__lving
revoting12312034revot___ing
rivalling1335964r__ivalling
rolling83620414r__o__lling
rootling9269954r_oot__ling
rotating92614554r__ota_ting
rowelling1366994r__owelling
settling978944set_t__ling
stalling95116704___stalling
subtotaling1453014subtota_ling
thralling13256834__thralling
tolling83418564__to__lling
totalising1147314__totalising
totalizing2079224__totalizing
towelling1366254__towelling

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.423422437.4
2DLD Change Limit1488191678.87616766.4
3Display Results1671670.0762197.4
 (SQL Overall)1786911679.37519060.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.