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

175 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
rathole1031205(None) 
ratholes11312411ratholes
armhole1236942armhole
cathode1338992cathode
kathode1545732kathode
manhole12311342manhole
pothole12312172pothole
rampole1139692rampole
ratable91717552ratable
rathe85821922rath__e
rattle64717612rat_tle
taphole1239772taphole
thole85620842__thole
ahold94714253_a_hold
airhole1048273airhole
amole75724593_a_mole
anethole1146253anethole
anole55330383_a_nole
areole61017283_areole
armholes1347383armholes
article9310923article
ashore9414613_ashore
asshole1046793asshole
atoll57913923_at_oll
atone56527983_at_one
awhile1257793_awhile
azole145118033_a_zole
bathe105822883bath__e
bathos116215633batho_s
bathoses13310463bathoses
bathrobe1544413bathrobe
battle85217863bat_tle
bolthole1345463bolthole
braciole1246973braciole
bracteole1343313bracteole
brattle9249253brat_tle
cajole154011183ca_jole
cariole9818343cariole
catchpole1843923catchpole
cathodes1439393cathodes
catholic15158383catholic
cathouse1338863cathouse
cattle85118903cat_tle
citole8311503cit_ole
coalhole1345093coalhole
dariole8711163dariole
datable101714233datable
dhole95215363__dhole
eatable91717603eatable
eyehole1346003eyehole
fathom1437473fatho_m
fathomed1744733fathomed
fathomer1645293fathomer
fathoms1537523fathoms
foxhole2045073foxhole
haole84820083ha__ole
hatable121713963hatable
hole77553393___hole
kathodes1646183kathodes
keyhole1764433keyhole
knothole1544073knothole
lathe85626713lath__e
mahoe10315573ma_ho_e
manholes13311183manholes
maypole1446383maypole
mudhole1344913mudhole
oilhole1046263oilhole
ostiole739013ostiole
outsole71013433outsole
parole84425253pa_role
pathogen1446463pathogen
pathos115516693patho_s
pathoses13412773pathoses
patrol83213023patrol_
patrols93513513patrols
pesthole1347553pesthole
petiole9311303petiole
piehole12188553piehole
pinhole122010433pinhole
porthole1349523porthole
posthole1339533posthole
potholed1448393potholed
potholes13312933potholes
prattle9208833prat_tle
rabble103818243ra_bble
rackle123917293ra_ckle
raddle84816173ra_ddle
radiale83813523radiale
radicle103510713radicle
radome9511873ra_dome
raffle123910703ra_ffle
raggle83712883ra_ggle
rale45050563ra___le
ramble104519973ra_mble
ramose8314403ra_mose
rampoles1238893rampoles
rankle103414883ra_nkle
raphae114311733raph_ae
raphe104916423raph__e
raphide13138073raphide
rashly123410213rash_ly
rassle63813203ra_ssle
ratables10159723ratables
ratably121711513ratably
ratafee1047523ratafee
ratal55025113rat_al_
ratals64219583rat_als
rate45458763rat___e
rateable10311443rateable
ratel54224883rat_el_
ratels64518213rat_els
rath76037663rath___
rather94319743rath_er
ratine65131823rat_ine
ratio55227583ratio__
ration64226013ratio_n
rationale949463rationale
rationed9410093rationed
rations74123433rations
ratios64922673ratio_s
ratite65022423rat_ite
ratlike113912353ratlike
ratline74517803ratline
rato45436973rat_o__
ratoon64417373rat_oon
ratooned977103ratooned
ratooner887003ratooner
ratoons73815473ratoons
ratos55528763rat_o_s
rattled84012953rat_tled
rattler74012743rat_tler
rattles73217303rat_tles
rattly94111543rat_tly
ratton64116123ratto_n
rattons73815323rattons
rattoon7359243rattoon
ravioli1055613ravioli
rawhide14134973rawhide
rechose121312043rechose
reshoe92816483resho_e
reshone102414163reshone
resole64624183r_esole
retable91820403retable
reticle94112623reticle
retile65929673ret_ile
retitle73913093retitle
retold73013753ret_old
retool63914483retool_
retooled938473retooled
retools73411023retools
retore67630773ret_ore
rissole739783rissole
role45851823r___ole
roothold1244763roothold
rutile65217683rut_ile
safrole1037253safrole
shothole1445513shothole
skatole1135693skat_ole
spathose1345633spathose
stole54928813_st_ole
tadpole1036143tadpole
tapholes1339623tapholes
tattle64115653tat_tle
tholed105113873__tholed
tholes94919783__tholes
those85218143__those
tole46052903__t_ole
tracheole1445573tracheole
trachle12311853trach_le
vacuole1245373vacuole
variole10711593variole
wattle94314213wat_tle
whole114418093__whole
wrathily1744773wrathily
xanthone1847113xanthone

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271756.84619577.4
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.32924381.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.