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 “rationing” with Change Limit: [1] [2] [3]

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

135 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
rationing103978(None) 
ratooning1037171ratooning
atoning83514872_at_oning
captioning1545702captioning
cautioning1345722cautioning
fractioning1744332fractioning
motioning1247542motioning
optioning1246552optioning
patining11312302pati_ning
radioing1039382radio_ing
raining83922692ra_i_ning
ratifying1656822ratifying
rattening10288762rattening
rattooning1143952rattooning
ravining12269692ravi_ning
stationing1145282stationing
aliening91510893_aliening
aligning10158533_aligning
alining81917043_ali_ning
aproning11311793_aproning
articling1247713articling
attorning1045503_attorning
attuning935903_attuning
auctioning1344893auctioning
batiking1537503bati_king
battening12268853battening
braining113414683bra_i_ning
buttoning1246463buttoning
cabining1338643cabi_ning
cannoning1237323cannoning
cantoning12310883cantoning
canyoning1536873canyoning
cartoning12311113cartoning
cartooning1345883cartooning
cationic12310013cationi_c
clarioning1345183clarioning
cottoning1237343cottoning
crayoning1535243cra_yoning
dragooning1342883dragooning
draining103312673dra_i_ning
fashioning1744393fashioning
fathoming1844693fathoming
fatiguing1443053fatiguing
fattening13287833fattening
gaining94015663ga_i_ning
gammoning1545063gammoning
graining102813183gra_i_ning
gratifying1874213gratifying
hamboning1745893hamboning
intoning9311123int_oning
jargoning1845983jargoning
jawboning22133413jawboning
latening9711493lat_ening
lesioning1046443lesioning
maligning13145583maligning
marathoning1752823marathoning
marooning1238593marooning
masoning1139763ma_soning
mentioning1345793mentioning
mutining11310493muti_ning
paining103920243pa_i_ning
pardoning1338763pardoning
pinioning1246863pinioning
platooning1344653platooning
portioning1347193portioning
radiating111112123radiating
radionics1244393radionics
raiding93617593ra_i_ding
railing83325643ra_i_ling
raising83220533ra_i_sing
ramifying1855603ramifying
ransoming1256513ransoming
rarifying1646313rarifying
rating74938703rat___ing
ration64226013ratio__n_
rational8412543ration_al
rationale949463rationale
rationals949943rationals
rationed9410093ration_ed
rations74123433ratio__ns
ratting83822363rat__ting
rattling92510873rat_tling
ravening122611293ra_vening
ravishing1634983ravishing
razoring1836443ra_zoring
realigning1245933realigning
reasoning10310203reasoning
recautioning1553763recautioning
reckoning1637643reckoning
recoining121313803recoining
refining122416863refi_ning
reigning1039883r_eigning
reining84425323r_ei_ning
rejoining17149223rejoining
relining93218743reli_ning
repining114116593repi_ning
repinning12258973repinning
resigning1139463resigning
resining92919553resi_ning
restationing1354263restationing
retaining102114733retaining
retieing92913713reti_eing
retiling93319483reti_ling
retiming113014193reti_ming
retinting102215253retinting
retiring92717413reti_ring
retitling1039773retitling
retooling1039093retooling
retuning9311583ret_uning
returning1038133returning
rewinning13257443rewinning
rezoning18310453r_ezoning
ribboning1443513ribboning
rinning83216743r__inning
rioting82716393r__ioting
rosining92411423rosi_ning
ruining83514883r_ui_ning
saining83621393sa_i_ning
sanctioning1453993sanctioning
satiating10311803satiating
sectioning1346293sectioning
staining9413373stai_ning
stoning83717443_st_oning
suctioning1345343suctioning
tamponing1445993tamponing
tattooing1043963tattooing
tining74927543__ti_ning
tinning83117283__tinning
toning74025793__t_oning
training93015863tra_i_ning
vacationing1753043vacationing
visioning1347063visioning
waggoning1543593waggoning
wagoning1336923wa_goning
wantoning1337083wantoning

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411356.82621775.7
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.04525364.2
 
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.