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

148 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
whortle1333594(None) 
chortle124210441chortle
whortles14306741whortles
chorale124313352chorale
chortled14326612chortled
chortler13336842chortler
chortles133611322chortles
hurtle93512942_hurtle
shortie10411342shortie
shortly13387572shortly
whistle13107532whistle
whittle13106102whittle
whole114418092who__le
whore116018042whor__e
whorl114612452whor_l_
whorled14366902whor_led
whorls124410162whor_ls
whort114623692whort__
whorts125111432whort_s
ahorse9311513ahor_se
aortae65115473_aortae
apostle937853apostle
bottle84916073_bottle
choral115118493choral_
chorales133712883chorales
chorals124614113chorals
chore105126763chor__e
chorine123218363chorine
chorten122811303chorten
chortlers14305663chortlers
dartle73714833_dartle
dhole95215363dho__le
dhootie1136473dhootie
dottle74212503_dottle
footle93914383_footle
forte86131463_fort_e
ghostly14355103ghostly
hantle94318203_hantle
hirple11158973_hirple
hirsle9159573_hirsle
hobble133913433_hobble
hogtie102711773_hogtie
hole77553393_ho__le
hondle103914523_hondle
hopple132910483_hopple
horal86328683_horal_
horde94623053_hor_de
horse86132653_hor_se
horste94817413_horste
hostel93914153_hostel
hostile10312553_hostile
hostler103411023_hostler
hostly124210863_hostly
hotel85520753_ho_tel
hotly115815483_ho_tly
hottie92514383_hottie
hoyle11314413_ho_yle
hurdle103712793_hurdle
hurtled11339593_hurtled
hurtles103913753_hurtles
hustle93113993_hustle
jostle13319863_jostle
kirtle10309473_kirtle
morale85220553_morale
mottle84116053_mottle
myrtle1135733_myrtle
orle45630463__or_le
phorate12413363phorate
portly114713403_portly
pottle84416103_pottle
rootle63214453_rootle
shore85432653shor__e
shorl84720253shor_l_
shorls94516203shor_ls
short85040533short__
shortage1236313shortage
shorted113614403shorted
shorten103511413shorten
shorter103515503shorter
shortia1048193shortia
shorties11414583shorties
shorts95321743short_s
shorty124313203short_y
shote85526103sho_t_e
shuttle1046103shuttle
sortie63621993_sortie
sporule937273sporule
spurtle937453spurtle
startle72511123startle
thistle10107803thistle
thole85620843tho__le
thorite10313443thorite
thorpe113610093thor_pe
throstle1175703throstle
throttle1164093throttle
tootle62613813_tootle
torte55431703_tort_e
tortile7313193_tortile
turtle63213573_turtle
warble113516603w_arble
warsle93112923w_arsle
warstle10328013warstle
wattle94314213w_attle
whale115517433wh__ale
wharve15456213whar_ve
wheedle1434833wheedle
wheeple1534873wheeple
where117019433wher__e
wherve15568123wher_ve
whiffle1933533whiffle
while115418693wh__ile
whirl114913823whir_l_
whirled14368043whir_led
whirler13307603whir_ler
whirls124710533whir_ls
whirly15448863whir_ly
whistled1595783whistled
whistler1496313whistler
whistles14108213whistles
white114920303wh_it_e
whittled1594913whittled
whittler1495193whittler
whittles1496673whittles
wholes124616773who__les
wholly15366573who_lly
whoopee15287523whoopee
whoopie15295933whoopie
whoopla1542633whoopla
whored135512123whor_ed
whores125617103whor_es
whoring142910293whoring
whorish1636603whorish
whose114914533who__se
wintle94014603w_intle
wobble133212313w_obble
woorali1045263woorali
wore77144673w_or__e
world96915363w_or_ld
worse86525263w_or_se
wort76654753w_ort__
worth117120523w_ort_h
worthed1437873w_orthed
worths127812893w_orths
worthy15598803w_orthy
worts88631183w_ort_s
wrastle10368993wrastle
wrestle10298843wrestle
wrote84717483wro_t_e

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 Limit1340271486.42320866.7
3Display Results1481480.0463217.4
 (SQL Overall)1786911486.87525991.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.