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 “rattlings” 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.

198 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
rattlings1023551(None) 
rattling92510871rattling_
bantlings12216602bantlings
battings114010572batt_ings
battling113110492battling_
bottlings12215292bottlings
brattling1236002brattling_
catlings113712042ca_tlings
fatlings12359302fa_tlings
fettlings1353752fettlings
mantlings12207232mantlings
mattings11369672matt_ings
prattling1246302prattling_
railings93412152ra_ilings
ratings84217412ra_t_ings
ratlines83815292ra_tlines
ratlins73615582ra_tlin_s
ratting83822362ratt_ing_
rattlingly1443652rattlingly
ravelings13377382ravelings
settlings1054682settlings
tattings9408822tatt_ings
tattling9259472tattling_
wattling12258782wattling_
ablings1038743_a_blings
actings104512463_act_ings
anglings10228273_anglings
antings85015583_ant_ings
athelings1345113_athelings
attains7310983_attain_s
attaints846493_attaints
babblings13194373babblings
bantling112612003bantling_
bastings114214693bast_ings
batting104422273batt_ing_
bittings11339293bitt_ings
bottling11279143bottling_
bramblings1742613bramblings
brandlings1443993brandlings
brittling1235543brittling_
cagelings1335413cagelings
callings113613833ca_llings
carlings114015863ca_rlings
castings113614053cast_ings
castling11311233castling_
catling104819793ca_tling_
catlins93818843ca_tlin_s
catting103922643catt_ing_
chitlings15255903chitlings
cracklings19143523cracklings
craterings1346003craterings
cuttings11277613cutt_ings
cuttling1138203cuttling_
dabblings15193883dabblings
darklings1533983darklings
darlings103710383da_rlings
dartling1039563dartling_
datelines1088853datelines
draftings14334213draft_ings
dratting10389663dratt_ing_
eanlings9128473ea_nlings
earthlings1443613earthlings
eastings93412953east_ings
eatings84616443ea_t_ings
failings123811013fa_ilings
farthings1635233farthings
fastings124011943fast_ings
fatling113815683fa_tling_
fatting113818703fatt_ing_
fettling1266773fettling_
fittings12318203fitt_ings
flatlings13315823flatlings
gantlines1039333gantlines
gatings95212823ga_t_ings
grapplings1642323grapplings
gratings103910763gra_t_ings
graylings1433883gra_ylings
guttling1037293guttling_
handlings14237343handlings
hatchings18225673hatchings
hatchlings1943033hatchlings
hatting113920233hatt_ing_
jottings16275193jott_ings
kartings13418523kart_ings
kitlings13318103_kitlings
kittling1336063kittling_
lastings94214423last_ings
lathings12469853la_things
latticings1342843latticings
lattins74115483latt_in_s
mailings113011923ma_ilings
mallings113413093ma_llings
mantling112012613mantling_
marblings14225543marblings
marlings113713493ma_rlings
matings104516213ma_t_ings
matting103620143matt_ing_
mattins93316143matt_in_s
mottling11197753mottling_
naethings1343873naethings
nestlings1074313nestlings
nettings9288103nett_ings
nettling957213nettling_
nuttings9276783nutt_ings
paddlings14224363paddlings
palings103915823pa__lings
panelings12107453panelings
partings113513733part_ings
patting103722343patt_ing_
pettings11349703pett_ings
pettling1168213pettling_
pittings11349123pitt_ings
prattlingly1752243prattlingly
rabbling13239333rabbling_
racings105015133ra__cings
raddling11229773raddling_
raffling1567063raffling_
rafting113815753raft_ing_
railing83325643ra_iling_
raisings9338443ra_isings
rallyings13313633rallyings
rambling131810773rambling_
rankings13389173ra_nkings
rankling132610113rankling_
ranting84025413rant_ing_
raspings11337853ra_spings
rassling939013rassling_
ratfinks1542853ra_tfinks
ratines75328583ra_t_ines
rating74938703ra_t_ing_
ratlin64116523ra_tlin__
ratline74517803ra_tlin_e
rattails837133rattai_ls
rattans73411953ratt_an_s
ratteens8256053ratteen_s
rattening10288763rattening_
rattens74213403ratt_en_s
rattlers83510293rattl_ers
rattles73217303rattl__es
rattons73815323ratt_on_s
rattoons8327513rattoon_s
raveling123414373raveling_
ravelins113011603ravelin_s
ravellings14214453ravellings
ravenings13235183ravenings
ravings114614503ra__vings
reattains946443reattain_s
reedlings11236343reedlings
reelings94012563r_eelings
restrings10159293restrings
retailings11265233retailings
retellings11244653retellings
retiling93319483retiling_
retitling1039773retitling_
retting83425883rett_ing_
ridglings12214183ridglings
rieslings1034493rieslings
riflings12227303r_iflings
rocklings16224843rocklings
rollings9419953r_ollings
rootling9269953rootling_
rotting82919683rott_ing_
rulings83310383r__ulings
rumblings14184633rumblings
rustling9249983rustling_
rutting82718043rutt_ing_
sailings93513253sa_ilings
saltings92811253salt_ings
samplings1435553samplings
sandlings11238093sandlings
saplings11269803sa_plings
scantlings1393313scantlings
settings93810073sett_ings
settling978943settling_
sittings9339733sitt_ings
slattings10346073slatt_ings
sprattling1363053sprattling_
stablings12256103stablings
starlings10237923starlings
stylings12276233_stylings
tacklings16235853tacklings
tailings93211673ta_ilings
tatting84019523tatt_ing_
tilings84212793__tilings
turtlings10184873turtlings
twattling1332693twattling_
vatting113614853vatt_ing_
vaultings13233643vaultings
vittling1236143vittling_
wafflings1943023wafflings
waitings123413743wait_ings
waterings13229253waterings
wettings12348403wett_ings
whittlings1742223whittlings
witlings12328443_witlings
wittings12328733witt_ings
wrastling1335523wrastling_
wrestlings1442933wrestlings

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.436409841.7
2DLD Change Limit1486411987.15620771.5
3Display Results1981980.0762605.3
 (SQL Overall)1786911987.66823303.5
 
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.