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

137 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
tailored93620(None) 
retailored1152952retailored
tabored102810562ta_bored
tailed74424662tail__ed
tailor63412502tailor__
tailors73212382tailor_s
tallowed12157712tallowed
taloned8310222ta_loned
trailered1045392trailered
trilobed1144202trilobed
adored84714233_a_dored
ailed66240283_ail__ed
aired66032923_ai__red
allowed111610073_allowed
alloyed11158033_alloyed
allured8299173_allured
arbored103811603_arbored
armored102610473_armored
bailed94726653bail__ed
bailor83412603bailor__
bailors93212403bailor_s
balloted1189043balloted
bilobed1235913_bilobed
calibred1335053calibred
colored10313473_colored
daikered1495223daikered
deplored1237223deplored
dialoged1146693dialoged
explored1845073explored
factored1436213factored
failed105421603fail__ed
failure1035753failure_
failures1135163failures
faired105915773fai__red
fallowed15127753fallowed
favored1455983fa_vored
galloped12107143galloped
galoped11138063ga_loped
galore73514843ga_lore_
galores82614323ga_lores
hailed104122743hail__ed
haired105117173hai__red
halloaed121510153halloaed
halloed113314913hallo_ed
hallooed12168773hallooed
hallowed15179493hallowed
haloed104717593ha_lo_ed
harbored1438633harbored
implored13135373implored
jailed144917423jail__ed
jailor13418573jailor__
jailors14328743jailor_s
kilorad1245393_kilorad
labored102810243la_bored
laired75216813lai__red
mailed95326753mail__ed
majored1735853ma_jored
milord999563_milor_d
minored10310103_minored
nailed74021493nail__ed
paired95017523pai__red
pastored1139963pastored
philtred14114183philtred
piloted10310323_piloted
railed74727543rail__ed
railroad943803railroad
rancored1137223rancored
razored1736333ra_zored
sailed74327763sail__ed
sailor63113743sailor__
sailorly1143533sailorly
sailors73213713sailor_s
sallowed12149033sallowed
savored1158343sa_vored
siloed74615303_silo_ed
tabered103311593ta_bered
tabled94020043tabl__ed
tableted1137533tableted
tabloid1048253tablo_id
tabooed10267383ta_booed
taborer9269293ta_borer
taboret92916113ta_boret
taboured1156273taboured
tailboard1245773tailboard
tailbone1045483tailbone_
tailbones1155253tailbones
tailcoated1343283tailcoated
tailer63823733tail__er
tailers73720183tailer_s
tailgated1145123tailgated
taille63116923tail_le_
tailles72516463tail_les
tailorbird13131183tailorbird
tailoring1036393tailoring
tailskid1343313tailskid
tailwind1243473tailwind
tainted83512423tai_nted
talced93811003ta_l_ced
talcked1446343ta_lcked
taliped1078203ta_liped
talked114015403ta_l_ked
tallaged10257923tallaged
tallied83314753ta_llied
tamboured1443783tamboured
tampered13279463tampered
tamponed1336023tamponed
tangoed9318833tango_ed
tapered102612933ta_pered
tared69340053ta___red
tarred74720283ta__rred
tattered92011443tattered
tattooed944573tattooed
tiered73613973t_i_ered
tiled64832943t_il__ed
tilled74722953t_il_led
tillered937433tillered
tilted74616863t_il_ted
tired65228903t_i__red
toiled74420323toil__ed
toileted936993toileted
trailed83415673trail__ed
tricolored1373633tricolored
triformed1543733triformed
trilled84116313tril_led
tutored837553t_utored
twilled11398033twil_led
unilobed1136393unilobed
vailed104619293vail__ed
vapored1336923va_pored
visored1138143_visored
vizored2034133_vizored
wailed104823593wail__ed
waired106015833wai__red
waitered1238753waitered
walloped14146833walloped
wallowed15148163wallowed
warlord1136293warlor_d

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621379.20315882.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911379.40518999.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.