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

177 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
chortled1432661(None) 
chortle124210441chortle_
chortler13336841chortler
chortles133611321chortles
charted135116852chart_ed
chorale124313352chorale_
chorales133712882chorales
chorded144710552chor_ded
chored125321882chor__ed
chorten122811302chort_en
chortlers14305662chortlers
chorused1446132chorused
hurtled11339592_hurtled
shorted113614402short_ed
whorled14366902whor_led
whortle13335942whortle_
whortles14306742whortles
aborted10310423abort_ed
bottled104611233_bottled
caroled103717693c_aroled
carolled1138833carolled
carted98631443c_art_ed
castled104311513c_astled
cavorted1435693cavort_ed
chanted134015953chant_ed
chared125423693char__ed
charged144614023char_ged
charked174814013char_ked
charley15118273char_ley
charmed154714253char_med
charred134614483char_red
charter123918303chart_er
chartered15158393chartered
chartless1435703chartless
chatted133411893ch_atted
cheated134416343cheat_ed
cheerled14105703cheerled
chertier1387873chertier
chested133811673chest_ed
chilled133310933ch_illed
chirked173810333chir_ked
chirmed15379733chir_med
chirped15379783chir_ped
chirred133612123chir_red
chiseled1435883chiseled
chocked194411613cho_cked
choired13349343cho_ired
choked164914793cho__ked
choler113717153cho__ler
chomped17329773cho_mped
chopped174511003cho_pped
choral115118493choral__
chorally1638103chorally
chorals124614113choral_s
chord115917263chor___d
chore105126763chor__e_
chorea115216093chor__ea
choremen1597603choremen
choreoid1447923choreoid
chores114828023chor__es
chorine123218363chorine_
chorines132917253chorines
chorioid1448333chorioid
choroid13311803chor_oid
chortens13308793chortens
chortling1535563chortling
choruses1339983choruses
chorussed1543213chorussed
choused135012463cho_used
chowed154914653cho__wed
chowsed16478613cho_wsed
chromed153510923ch_romed
chuckled2045163chuckled
churched1934653churched
churned13358373chur_ned
churred13409173chur_red
chuted124611843ch_ut_ed
circled1237583c_ircled
clothed134010283clo_thed
clotted104011823clo_tted
clouted104212163clout_ed
coaled95022713c_o_aled
coated94927043c_oat_ed
cobbled143411633c_obbled
cockled163710823c_ockled
coddled123410573c_oddled
coffled16297363c_offled
cohosted1436133cohost_ed
coiled95123943c_o_iled
coled85540763c_o__led
cooled95224593c_o_oled
coopted123710763coopt_ed
corbeled1338373c_orbeled
corded105923353c_or_ded
cored85044223c_or__ed
corked135020783c_or_ked
corned95224523c_or_ned
cornfed1337383c_ornfed
corslet9318063c_orslet
cortex15311473c_ort_ex
coruler9311713c_oruler
costed95623113c_ost_ed
coted85033853c_o_t_ed
coupled124312673c_oupled
courted103514923court_ed
cowled125218393c_o_wled
cuittled1133993cuittled
curdled113910663c_urdled
curled95021653c_ur_led
cuttled10319933c_uttled
dartled9409853_dartled
dehorted1357303dehort_ed
exhorted1935013exhort_ed
footled113610763_footled
ghosted1236273ghost_ed
hirpled13157143_hirpled
hirsled11118113_hirsled
hobbled153310783_hobbled
hogtied12226653_hogtied
holed95634133_ho__led
hondled123510653_hondled
hooted104422663_hoot_ed
hoppled15338083_hoppled
horded115420483_hor_ded
horned105718703_hor_ned
horsed105321083_hor_sed
hosted105020343_host_ed
hosteled1237293_hosteled
hostler103411023_hostler
hotbed123310683_ho_tbed
hotted104319943_ho_tted
hoveled14209293_hoveled
howled134014973_ho_wled
hurdled12379833_hurdled
hurled104617453_hur_led
hurtle93512943_hurtle_
hurtles103913753_hurtles
hustled113210133_hustled
jostled15267083_jostled
kirtled12287033_kirtled
mottled10409973_mottled
outled74020343__outled
photoed1338913pho_toed
portaled11239203_portaled
ported94223243_port_ed
rootled83410533_rootled
schooled1447053scho_oled
shoaled113810973sho_aled
shooled115212663sho_oled
shored105723653shor__ed
shorten103511413short_en
shortened1345663shortened
shorter103515503short_er
shorthead1644473shorthead
shortie10411343shortie_
shorties11414583shorties
shortly13387573shortl_y
shotted113912403sho_tted
shouted113911553shout_ed
shoveled15195353shoveled
shuttled1234673shuttled
snorted83813493snort_ed
sorted74523713_sort_ed
sortied83314103_sortied
sported104015433sport_ed
startled9208563startled
thirled11328093thir_led
tholed105113873tho__led
thorned11479403thor_ned
throttled1352963throttled
tootled83511043_tootled
turtled8309683_turtled
whirled14368043whir_led
whistled1595783whistled
whittled1594913whittled
whored135512123whor__ed
worthed1437873_worthed

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621777.15620425.1
3Display Results1771770.0632809.5
 (SQL Overall)1786911777.68923239.8
 
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.