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

150 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
toileted93699(None) 
colleted113011662colleted
fileted1159092_fileted
tableted1137532tableted
tilted74616862t_il_ted
toiled74420322toil__ed
toilet66228092toilet__
toiletry1144102toiletry
toilets74112912toilet_s
toilette846682toilette
toilettes946022toilettes
toited74016752toi__ted
billeted1137643billeted
bilsted1038033_bilsted
boiled95020953boil__ed
bolete8519613bo_lete_
boletes9316063bo_letes
bolted94617803bo_l_ted
bonneted1136223bonneted
bulleted1138393bulleted
coiled95123943coil__ed
collated113615063collated
collected1447973collected
competed154113593competed
completed162810273completed
corseted11311473corseted
cosseted1178343cosseted
coveted133011523co_veted
deleted93314913_deleted
depleted12258723depleted
dieted83115493_di_eted
dilated93115823_dilated
diluted9248933_diluted
docketed16156583docketed
doiled84817293doil__ed
doited85016633doi__ted
epilated11310753epilated
etiolated1047073etiolated
filleted1236603filleted
foiled104618403foil__ed
foisted113210603foi_sted
foliated1249913foliated
galleted1038213galleted
gimleted1243973gimleted
gorgeted1135353gorgeted
hilted104016043_hil_ted
hoidened1335653hoidened
hoisted113411293hoi_sted
hollered1237603hollered
isleted837523_isleted
jilted144111353_jil_ted
jointed15378503joi_nted
joisted15379173joi_sted
jolted143510633jo_l_ted
kilted113613833_kil_ted
lilted73715373_lil_ted
loitered938183loitered
milted93919943_mil_ted
moiled94318863moil__ed
molested11178243mo_lested
molted94217473mo_l_ted
moulted103310313moul_ted
oiled64429473_oil__ed
oilseed835783_oilseed
palleted1139873palleted
pelleted1138203pelleted
pileated112711133_pileated
piloted10310323_piloted
pocketed17147143pocketed
pointed103813983poi_nted
pollened1157783pollened
polluted1135433polluted
quieted17309723qui_eted
quilted17319313quil_ted
riveted11258573_riveted
rocketed15157793rocketed
roiled74320053roil__ed
roqueted1834653roqueted
rouletted1045053rouletted
silted74020013_sil_ted
socketed15177343socketed
soiled73822473soil__ed
solated83618023so_lated
sonneted936183sonneted
stilted83511473stil_ted
tabletted1244833tabletted
tailed74424663tail__ed
tailgated1145133tailgated
tailored936203tailored
tainted83512423tai_nted
talented938423t_alented
targeted1037483targeted
telexed1536323t_elexed
telneted935073telneted
thicketed1943613thicketed
thieved1434973thi_eved
thirsted1235213thirsted
ticketed15146643ticketed
tiered73613973t_i_ered
tiled64832943t_il__ed
tilled74722953t_il_led
tillered937443tillered
tilter63417693t_il_ter
tincted1037273t_incted
tinted74419533t_i_nted
toasted84011923to_asted
tochered1437913tochered
togated94410663to_gated
toile54626493toil__e_
toiler63918283toil__er
toilers74116263toile_rs
toiles63923513toil__es
toileting1036263toileting
toiletries1046613toiletries
tokened1236393to_kened
toled65934923to_l__ed
tolerated1049123to_lerated
tolled73819033to_l_led
tonlet62924703tonlet__
tonlets73212503tonlet_s
tooled74918903tool__ed
toolshed1244213toolshed
tooted74620123to__oted
tormented1245963tormented
toted64929483to___ted
totted74319953to__tted
tottered9208703tottered
touted74419743to__uted
toweled112410223to_weled
towelled1236353towelled
towered112911403to_wered
trailered1045393trailered
trilled84116313tril_led
trilobed1144203trilobed
trimeter10310083trimeter
trinketed1444253trinketed
trisected1244913trisected
troilite849543troilite_
troilites948433troilites
trolleyed1342473trolleyed
turreted935373turreted
tweeted11336583t_weeted
twilled11398033twil_led
twisted11277433twi_sted
twitted11326633twi_tted
valeted1139013_valeted
violated1237883violated
volleyed1543533volleyed
voluted11297943vo_luted
wilted103915713_wil_ted

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621507.70318974.7
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.17221866.3
 
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.