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

174 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
awhirl126467(None) 
whirl114913821_whirl
achiral12109182achiral
aswirl935092aswirl
awhile1257792awhile
swirl84514142sw_irl
thirl85416822_thirl
twirl85011942tw_irl
whir105519282_whir_
whirls124710532_whirls
whirly15448862_whirly
whirr114611192_whirr
whirs115218092_whirs
whorl114612452_whorl
aahing1019015763aahing
abhor10411063abhor_
abhors11410623abhors
aboil72217543aboi_l
achier113914263achier
aching126521973aching
adhere10310333adhere
admiral1046363admiral
admire949933admire
aecial84817313aecial
aerial64625713aerial
affirm1435523affirm
afire86215913a_fire
ahi68040233a_hi__
ahing98928353a_hing
ahis76135383a_hi_s
ahull84010313a_hull
ail37171043a__i_l
air38058393a__ir_
airn46433833a__irn
airs46447423a__irs
airt45757783a__irt
airy75734153a__iry
amir65129753a_mir_
amirs75924923a_mirs
anil46437433a_ni_l
anthill1048203anthill
anvil82712603anvi_l
aphid115515393aphi_d
aphids125110843aphids
aphis105917133aphi_s
archil11611573archi_l
argil65116883argi_l
ariel55228973a_riel
aril45843023a_ri_l
ashier94714833ashier
ashing107824093ashing
ashore9414613ashore
aspire8612123aspire
astir55517093astir_
athirst1037873athirst
atrial65418943atrial
attire62412383attire
audial7312993audial
avail8313883avai_l
await85524493awai_t
awaits96411953awaits
award97118043aw_ard
aware86420023aw_are
aweary1237303aweary
aweigh1334933aweigh
aweing103911253aweing
awful1178143aw_ful
awing96827323aw_ing
awl67635303aw___l
awning105013393awning
awol75620673aw__ol
awry107619683aw__ry
axial124515193a_xial
axil116424453a_xi_l
batgirl1043393batgirl
birl65830473__birl
chiel104918973_chiel
chill105619873_chill
chiral114614413_chiral
chirk144516183_chirk
chirm125317063_chirm
chiro105320343_chiro
chirp124717163_chirp
chirr105015903_chirr
chiru105317153_chiru
churl105913883_churl
cowgirl1353273cowgirl
dirl57430023__dirl
girl56226553__girl
harl75740003__harl
herl75834553__herl
hill76439493__hill
hire75538963__hire
hurl76029933__hurl
nihil8410283nihi_l
outwhirl1443183outwhirl
phial10313203_phial
rachial122012173rachial
rawhide14134973rawhide
rehire95415863rehire
sawbill1255293sawbill
sawmill1244073sawmill
schorl1179813schorl
shiel811023773_shiel
shill85325333_shill
shire84727133_shire
shirk124817843_shirk
shirr84716923_shirr
shirt84533903_shirt
shorl84720253_shorl
skirl96012913_skirl
swail86217163swai_l
swill83417373sw_ill
swirls94010133sw_irls
swirly12439253sw_irly
thill85918733_thill
thiol87616043_thiol
thir76420543_thir_
third95912493_third
thirls95012063_thirls
thurl84912683_thurl
tirl45029923__tirl
twill85612723tw_ill
twirls9478123tw_irls
twirly12427083tw_irly
twirp10468943tw_irp
uphill11106173uphill
virl76224473__virl
wahine123813013wahine
wail75238823_wai_l
wair75830053_wair_
wairs86424063_wairs
weir76019923_weir_
weird95111283_weird
weirs84316493_weirs
wharf14315823_wharf
wheal115716183_wheal
wheel115515333_wheel
where117019423_where
which163910083_which
whid115418873_whi_d
whids125413983_whids
whiff17310063_whiff
whig115516423_whi_g
whigs125612643_whigs
while115418693_while
whim126220533_whi_m
whims134515333_whims
whin105225693_whi_n
whine116022813_whine
whins114922333_whins
whiny144915573_whiny
whip125521843_whi_p
whips134917083_whips
whipt135317423_whipt
whirled14368043_whirled
whirler13307603_whirler
whirrs12408593_whirrs
whirry15477063_whirry
whish144512923_whish
whisk154510143_whisk
whist115322953_whist
whit104834173_whi_t
white114920303_white
whits115923823_whits
whity145513473_whity
whiz195919943_whi_z
whizz194210323_whizz
whore116018043_whore
whorls124410163_whorls
whort114623693_whort
will75737513_w_ill
wire75839813_w_ire
wiry106422833_w_iry

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161745.20321663.7
3Display Results1741740.0463782.6
 (SQL Overall)1786911745.62231784.2
 
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.