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

155 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
chortling153556(None) 
charting142614192chart_ing
chitling142910662ch_itling
chording15410152chor_ding
choring133617662chor__ing
chorusing15246112chorusing
hurtling12318312_hurtling
shorting122514802short_ing
aborting11710253abort_ing
bottling11279143_bottling
carling103727063c_ar_ling
caroling113317003c_aroling
carolling1259413carolling
carting104228283c_art_ing
castling11311233c_astling
catling104819793c__atling
cavorting1536063cavort_ing
chanting143413533chant_ing
charging152910773char_ging
charing133721323char__ing
charking183512613char_king
charming163012033char_ming
charring142913163char_ring
chartering16109253chartering
chatting142810143ch_atting
cheating144014523cheat_ing
chilling143512183ch_illing
chirking18339383chir_king
chirming16318643chir_ming
chirping16278863chir_ping
chirring142610173chir_ring
chiseling1536403chiseling
chitlin12269283ch_itlin_
chitlings15255903ch_itlings
chitlins13289393ch_itlins
chocking204011013cho_cking
choiring14279793cho_iring
choking173911943cho__king
choline122915383cho__line
chomping18339883cho_mping
choosing142010133cho_osing
chopping183710263cho_pping
chorine123218363chor__ine
chorten122811303chort_en_
chortens13308793chort_ens
chortle124210443chortl__e
chortled14326613chortl_ed
chortler13336843chortl_er
chortlers14305663chortlers
chortles133611323chortl_es
chorussing16193323chorussing
chousing14259423cho_using
chowing164412773cho__wing
chowsing17217343cho_wsing
chroming163410723ch_roming
chuckling2144193chuckling
churching2055083churching
churning14237173chur_ning
churring14298653chur_ring
chuting132910733ch_ut_ing
circling1338423c_ircling
clothing14278783clo_thing
clotting113110643clo_tting
clouting113011683clout_ing
coaling103722823c_o_aling
coating103525313c_oat_ing
cobbling15248803c_obbling
cockling172310393c_ockling
coddling13258473c_oddling
codling114418953c_o_dling
coffling1736483c_offling
cohosting1546323cohost_ing
coiling103723453c_o_iling
cooling103422573c_o_oling
coopting133411313coopt_ing
corbeling1439033c_orbeling
cording113620823c_or_ding
coring94433963c_or__ing
corking143018823c_or_king
corning103720123c_or_ning
cortin82423153c_ort_in_
cortina91915973c_ort_ina
cortins92421333c_ort_ins
costing104323023c_ost_ing
coting94629253c_o_t_ing
coupling13310783c_oupling
courting112514573court_ing
cowling134017423c_o_wling
cuittling1234103cuittling
curdling12228893c_urdling
curling104320183c_ur_ling
cuttling1138203c_uttling
dartling1039563_dartling
dehorting1447213dehort_ing
exhorting2045733exhort_ing
footling12239923_footling
ghosting1336463ghost_ing
hireling121210993_hireling
hirpling1467223_hirpling
hirsling1277543_hirsling
hobbling16227583_hobbling
hogtying1633553_hogtying
holing104025073_ho__ling
hondling132210013_hondling
hooting113919883_hoot_ing
hoppling16206763_hoppling
hording123517053_hor_ding
horning113015003_hor_ning
horsing113215583_hor_sing
hosteling1337893_hosteling
hosting114318383_host_ing
hotline10712353_ho_tline
hotlink1476763_ho_tlink
hotting113116523_ho_tting
hoveling15189593_hoveling
howling143413163_ho_wling
hurdling13288013_hurdling
hurling113616413_hur_ling
hurting113914033_hurt_ing
hustling12228793_hustling
jostling16207123_jostling
lordling1077743_lordling
mottling11197753_mottling
northing12199063_northing
photoing1439073pho_toing
porting103021783_port_ing
rootling9269953_rootling
schooling1546943scho_oling
shirting123213613shirt_ing
shoaling123111753sho_aling
shooling123012563sho_oling
shooting122812863shoot_ing
shoreline1246623shoreline
shoring112820073shor__ing
shortening1445303shortening
shortlist1246683shortlist
shotting123012383sho_tting
shouting122711793shout_ing
shoveling1635553shoveling
shuttling1334293shuttling
snorting92613373snort_ing
sorting83221813_sort_ing
sporting112415463sport_ing
startling1037373startling
thirling12248583thir_ling
tholing112812333tho__ling
thorning1237513thor_ning
throttling1442793throttling
tootling9279523_tootling
turtling9238833_turtling
whirling15237163whir_ling
whistling1644733whistling
whittling1634383whittling
whoring142910293whor__ing
worthing15178053_worthing

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411557.97018650.1
3Display Results1551550.0632460.3
 (SQL Overall)1786911558.45621131.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.