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

166 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
chortler1333684(None) 
chortle124210441chortle_
chortled14326611chortled
chortlers14305661chortlers
chortles133611321chortles
charter123918302chart_er
chertier1387872chertier
choler113717152cho__ler
chorale124313352chorale_
chorales133712882chorales
chorten122811302chort_en
coruler9311712c_oruler
hostler103411022_hostler
shorter103515502short_er
whortle13335942whortle_
whortles14306742whortles
aborter939933abort_er
bottler94211883_bottler
caroler93816753c_aroler
caroller1039203caroller
carter84932273c_art_er
cavorter1335783cavort_er
chandler14358373chandler
chanter123919733chant_er
chapter144213853chapt_er
charger133914063char_ger
charier124317903char_ier
charley15118273char_ley
charmer144913663char_mer
charrier1378683charrier
charted135116853chart_ed
charterer14197323charterer
charters134115583chart_ers
chartless1435703chartless
chaster124718503chast_er
chatter124416643ch_atter
chattier1337513chattier
cheater124816963cheat_er
chestier1387423chestier
chiller124112183ch_iller
chirker16429323chir_ker
chirper14359963chir_per
chirpier15276303chirpier
chiseler1335903chiseler
chitter124112963ch_itter
choicer14197893cho_icer
choker154314373cho__ker
chokier1638043cho_kier
cholera12409093cho__lera
cholers124215203cho__lers
chomper163810073cho_mper
chooser124412973cho_oser
choosier1337173choosier
chopper163611893cho_pper
choppier17286643choppier
choral115118493choral__
chorally1638103chorally
chorals124614113choral_s
chorded144710553chor_ded
chore105126763chor__e_
chorea115216083chor__ea
chored125321883chor__ed
choremen1597603choremen
chores114828023chor__es
chorine123218363chorine_
chorines132917253chorines
chorister1487143chorister
chortens13308793chortens
chortling1535563chortling
chorused1446133chorused
choruses1339983choruses
chouser125212943cho_user
chowder16387813cho_wder
chromier1538033chromier
chuckler1935553chuckler
chunter123911483chunt_er
churner12298343chur_ner
circler1136423c_ircler
clouter93511693clout_er
coaler84121713c_o_aler
coater84329573c_oat_er
cobbler133311823c_obbler
coddler113710833c_oddler
coiler84421593c_o_iler
colter84625093c_olt_er
cooler84824713c_o_oler
cooter85128613c_oot_er
copter109822013c_opt_er
corder94322883c_or_der
corer75538873c_or__er
corker124720853c_or_ker
corkier133114303c_orkier
corner84625623c_or_ner
cornier93017093c_ornier
coroner94218203c_oroner
corslet9318063c_orslet
cortex15311473c_ort_ex
corulers1039773c_orulers
coster84331293c_ost_er
costlier1038523c_ostlier
cotter84926673c_o_tter
cottier93814173c_ottier
coulter94115603c_oulter
coupler114713013c_oupler
courter94516483court_er
courtier1059333courtier
courtlier1154463courtlier
couter84930223c_out_er
couther123914633c_outher
crofter12299573croft_er
curdler103511563c_urdler
curler85221323c_ur_ler
curter85320083c_urt_er
cutler84718033c__utler
exhorter1845353exhort_er
footler104011873_footler
ghostier1235383ghostier
ghostlier1343343ghostlier
hobbler143710403_hobbler
holler93520613_ho_ller
hooter94123933_hoot_er
hootier104915353_hootier
hornier103012463_hornier
horsier103013243_horsier
hosteler1137283_hosteler
hostlers113310483_hostlers
hotter94720083_ho_tter
howler123514313_ho_wler
hurdler113610003_hurdler
hurler94717223_hur_ler
hurter93915853_hurt_er
hurtle93512943_hurtle_
hurtled11339593_hurtled
hurtles103913753_hurtles
hustler103410753_hustler
jostler14288223_jostler
mottler94410343_mottler
norther1039733_norther
ostler63312193__ostler
porter84224413_port_er
portlier1038373_portlier
shirtier1137943shirtier
shoaler102610083sho_aler
shooter103013993shoot_er
shorted113614403short_ed
shorten103511413short_en
shortener1245773shortener
shortie10411343shortie_
shorties11414583shorties
shortly13387573shortl_y
shouter103213083shout_er
shoveler14165583shoveler
shuttler1164903shuttler
snorter74412663snort_er
sorter64425093_sort_er
sporter93616553sport_er
sportier102010053sportier
startler8248793startler
thornier1135323thornier
throttler1262863throttler
tootler73511123_tootler
turtler72610323_turtler
whirler13307603whir_ler
whistler1496313whistler
whittler1495193whittler
whorled14366903whor_led

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.436409841.7
2DLD Change Limit1461621667.31319986.6
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.81222873.9
 
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.