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

136 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
whirliest1521604(None) 
whirlies14167371whirlies_
chilliest14358912chilliest
chirpiest16286472chirpiest
girliest93010402_girliest
hilliest113914112_hilliest
shirtiest1239322shirtiest
swirliest1236292swirliest
twirliest1234502twirliest
whiniest14298752whi_niest
whinniest15245132whinniest
whippiest19265112whippiest
whirlier14175292whirlie_r
whirries14136692whirries_
whitiest14259882whi_tiest
whizziest2342882whizziest
wiliest103416592w_i_liest
wiriest103816852w_ir_iest
airiest74221013_air_iest
bairnliest1242623bairnliest
burliest103113063_burliest
chariest13315503char_iest
charlies133414233charlies_
charriest1438253charriest
chertiest1438793chertiest
chichiest1936343chichiest
childliest1653863childliest
chiliast13117933chi_liast
chilies124218303chi_lies_
chillest13259593chi_llest
chillies134113483chillies_
chinkiest1867023chinkiest
chippiest18256803chippiest
chirkest1735383chir_kest
curliest102713123_curliest
dirtiest93014203_dirtiest
earliest82415243_earliest
firriest112310433_firriest
flirtiest1236193flirtiest
frilliest1237113frilliest
gainliest1037133gainliest
ghillies12408663ghillies_
girlies83013703_girlies_
gnarliest10186553gnarliest
grisliest1047353grisliest
hairiest11612463hair_iest
hardiest123416333_hardiest
herbiest1339993_herbiest
hinkiest153311753_hinkiest
hippiest152611613_hippiest
hissiest112911093_hissiest
holiest104319623_h_oliest
horniest112814043_horniest
horsiest112513263_horsiest
hurlies103315333_hurlies_
knurliest1344073knurliest
marliest102415183_marliest
miriest93619823_mir_iest
mirkiest142910253_mirkiest
nearliest949363nearliest
oiliest72817683_oi_liest
pearliest1139353pearliest
quirkiest2234373quirkiest
roiliest8312283roi_liest
shaliest111415053sh_aliest
shelliest1238023shelliest
shiftiest1537363shiftiest
shiniest113212493shi_niest
shitlist1148723shitli_st
shittiest1238333shittiest
shoaliest1238503shoaliest
shrillest1245393shrillest
silliest84017103_silliest
smirkiest1535193smirkiest
snarliest91810203snarliest
spiriest102513453spir_iest
stilliest939223stilliest
surliest82416913_surliest
thirstiest1343973thirstiest
thirties1139723thirties_
thistliest1344383thistliest
thorniest1236483thorniest
wabbliest16274963wabbliest
waffliest1844233waffliest
waggliest1434783waggliest
waitlist1147743waitli_st
wambliest16255153wambliest
wariest105122503w_ar_iest
wartiest113614643w_artiest
weakliest1635853weakliest
weariest112914793wear_iest
weirdest1244433weir_dest
weirdies12255783weirdies_
whackiest2144983whackiest
wheelies1437863wheelies_
wheeziest2443663wheeziest
whelkiest1943963whelkiest
wherries14179023wherries_
whiles124418013whi_l_es_
whilst1239143whi_l__st
whimsies1635193whimsies_
whinnies14237273whinnies_
whirled14368043whirl_e_d
whirler13307603whirl_e_r
whirlers14286053whirl_ers
whirligig175863whirligig
whirling15237163whirli_ng
whirls124710533whirl__s_
whirried15154103whirrie_d
whiskies1835953whiskies_
whitest133710113whi__test
whities133113253whi_ties_
wieldiest1334803w_ieldiest
wifeliest1545883wifeliest
wiftiest14279173w_iftiest
wiggiest13269013w_iggiest
wiggliest1444883wiggliest
wildest113311273w_i_ldest
willies103920153w_illies_
wimpiest1538763w_impiest
windiest122213233w_indiest
wingiest123214283w_ingiest
winiest103419693w_i_niest
wiseliest1237723wiseliest
wispiest1339513w_ispiest
withiest142411243w_ithiest
wittiest112711523w_ittiest
wobbliest16275333wobbliest
wooliest113011643w_ooliest
woolliest1235853woolliest
wordiest122311543w_ordiest
wormiest13249543w_ormiest
wriest94419713w__r_iest
wriggliest1542933wriggliest
wrinkliest1743833wrinkliest
wristiest1237753wristiest

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411366.21623912.6
3Display Results1361360.0632158.7
 (SQL Overall)1786911366.43527768.6
 
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.