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

163 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
exhorts174631(None) 
exhort16410801exhort_
exports1647981exports
extorts1447751extorts
cohorts123411102cohorts
dehorts11379772dehorts
efforts1334702efforts
ephors11311402ephor_s
escorts9418402escorts
exerts133712292ex_erts
exhorted1935012exhorted
exhorter1845352exhorter
exhorters1944712exhorters
experts1659062experts
export15412182export_
exserts1467012exserts
extort13513972extort_
shorts95321742_shorts
whorts125111432_whorts
abhors11410623abhor_s
aborts84916183_aborts
assorts73310153assorts
beshouts1346763beshouts
bethorns1337323bethorns
bhoots11459913_bhoots
borts76735453__borts
cahoots1238473cahoots
cavorts1237933cavorts
charts115823093_charts
cherts115617233_cherts
chords125214633_chords
chores114828023_chores
chorus115014773_chorus
chotts113610993_chotts
cohort1110720263cohort_
cohosts12398813cohosts
dehorns11428363dehorns
dehort104618103dehort_
deports105012883deports
echards1337963echards
echoers12459693echoers
echoes114715523echo_es
echos105216463echo__s
effort1238623effort_
encores9315213encores
enroots738713enroots
ephods1238363epho_ds
ephor10310013ephor__
ephoral1248403ephoral
ephorate1359503ephorate
ephorates1459163ephorates
ephori1139603ephor_i
ergots74512373ergo_ts
errors63311313error_s
escort84616483escort_
escots84211743esco_ts
ethers94518413ether_s
ethos85514193etho__s
ethoses10311763ethoses
everts94514893e_verts
exacts15359613ex_acts
exahertz2743243exahertz
exalts13328313ex_alts
excepts1885203excepts
excerpts1943743excerpts
exempts1844023exempts
exert124624143ex_ert_
exhales1737143exhales
exhaust1744243exhaust
exhausts1842963exhausts
exhibits2044143exhibits
exhorting2045733exhorting
exhumes1934323exhumes
exists134710913ex_ists
exits125515913ex__its
exodos1435943ex_odos
exodus1434653ex_odus
exons125813343ex_o_ns
expats1537683ex_pats
expects1866883expects
expert15515353expert_
expires1638683expires
exploits1745973exploits
explores1746253explores
exported1837133exported
exporter1737363exporter
exporters1846253exporters
expos1449203expo__s
exposes1639963exposes
exposits1747243exposits
exsects1655573exsects
exsert13414363exsert_
extents142610173extents
externs1438233externs
extolls1444603extolls
extols1337683exto_ls
extorted1636233extorted
extorter1546513extorter
extorters1645763extorters
extras13310223ex_tras
exults13257633ex_ults
exurbs1534423ex_urbs
felworts1445953felworts
forts86034453__forts
ghosts10489273_ghosts
harts88441593__harts
holts85627913__holts
hoots84830253__hoots
horas86333103__horas
horns86125333__horns
horst85833513__horst
horsts95817513__horsts
hosts85526703__hosts
hots78349333__ho_ts
hurts86922823__hurts
ichors11310423ichor_s
imports11309623imports
intorts7310973intorts
ixoras1337193ix_oras
jetports1743533jetports
leghorns1244903leghorns
mahouts1237143mahouts
morts75533563__morts
orts46538333___orts
oxcarts1634313oxcarts
oxfords1842893oxfords
oxhearts1842903oxhearts
phots105418503_pho_ts
ports75934593__ports
recharts1337663recharts
reexports1843243reexports
reports94916213reports
reshoots11228413reshoots
resorts74817193resorts
retorts76016513retorts
saxhorns1843833saxhorns
schorls1248353schorls
seaports1038463seaports
senhoras11278283senhoras
senhores112810993senhores
senhors103512133senhor_s
sexpots1636293sexpo_ts
shirts94918343_shirts
shoats94117083_shoats
shoots94619363_shoots
shores94830413_shores
shorls94516203_shorls
short85040533_short_
shorty124313203_shorty
shots84730853_sho_ts
shotts93614703_shotts
shouts94017723_shouts
skorts104211303_skorts
snorts64116503_snorts
sorts54536663__sorts
sports84619183_sports
thorns95314103_thorns
thorps113610893_thorps
torts56138123__torts
whores125617103_whores
whorls124410163_whorls
whort114623693_whort_
worts88631183__worts

Search took 7 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.406440125.6
2DLD Change Limit1340271636.18621666.2
3Display Results1631630.0463543.5
 (SQL Overall)1786911636.63826919.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.