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

172 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
shoaliest123850(None) 
shaliest111415051sh_aliest
shoalest1168911shoal_est
coaliest10316222_coaliest
hoariest11312882_hoariest
holiest104319622_ho_liest
scaliest101714392s_caliest
shadiest121711272sh_adiest
shakiest151910932sh_akiest
shelliest1238022shelliest
shoalier1137072shoalie_r
shoddiest1434752shoddiest
shouldest1344142shouldest
showiest1438782sho_wiest
soapiest102412842s_oapiest
chalkiest1837083ch_alkiest
chariest13315503ch_ariest
chilliest14358913chilliest
chokiest1738723cho_kiest
choosiest1437323choosiest
choppiest18226373choppiest
croakiest15167173croakiest
dhoolies1246963dhoolies_
drooliest1036343drooliest
floatiest1237283floatiest
foamiest13289853_foamiest
ghostiest1336543ghostiest
ghostliest1453713ghostliest
ghoulies1235393ghoulies_
goalies8316023_goalies_
godliest1039453_godliest
goodliest1146393goodliest
growliest1335583growliest
halest94823273_h_al_est
haziest193313003_h_aziest
headiest123015553_headiest
heaviest143210443_heaviest
hilliest113914113_hilliest
hoagies112811993_hoagies_
hoarsest1137133_hoarsest
hokiest144114243_ho_kiest
holies94630033_ho_lies_
holist94723213_ho_li_st
hollies103420813_hollies_
homeliest1448553_homeliest
homiest124116633_ho_miest
hoodiest122413173_hoodiest
hookiest152712103_hookiest
hootiest113115643_hootiest
hoppiest152610723_hoppiest
horniest112814043_horniest
horsiest112513263_horsiest
jolliest152910363_jolliest
jowliest18247623_jowliest
loamiest102310203_loamiest
lowliest11229473_lowliest
mealiest102215973_mealiest
motliest10310773_motliest
oakiest112913923__oakiest
oiliest72817683__oiliest
paliest93021603__paliest
phoniest132811533pho_niest
roiliest8312283_roiliest
sagiest82617983s__agiest
salient7419763s__alient
saltest71916513s__altest
saltiest83117713s__altiest
scariest101615943s_cariest
schmalziest2751663schmalziest
scholiast1446303scho_liast
scrawliest1553813scrawliest
seamiest102715413s_eamiest
seemliest1145623seemliest
shabbiest1635323shabbiest
shaggiest14156893shaggiest
shales94731253sh_al_es_
shalier103116423sh_alie_r
shapeliest1544963shapeliest
sharpest1339143sh_arpest
shavies134213203sh_avies_
sheeniest12158353sheeniest
shelviest1535003shelviest
shiest95821523sh___iest
shiftiest1537363shiftiest
shiniest113212493sh_iniest
shirtiest1239323shirtiest
shitlist1148723shitli_st
shittiest1238333shittiest
shlockiest1942903shlockiest
shmaltziest2551483shmaltziest
shoaled113810973shoal_e_d
shoaler102610083shoal_e_r
shoaling123111753shoali_ng
shoals94215793shoal__s_
shoddies1336053shoddies_
shoeless1137803shoel_ess
shooflies1544143shooflies_
shoplift1645193shopli_ft
shoplifts1742763shoplifts
shortest11310783sho_rtest
shorties11414583shorties_
shortlist1246683shortli_st
shouldst1243393shoul_dst
shrillest1245393shrillest
sickliest1547523sickliest
silliest84017103s_illiest
slatiest82616263s_latiest
sleaziest1836053sleaziest
sliest66621953s___liest
slobbiest1345083slobbiest
sloppiest1345973sloppiest
sloshiest1246673sloshiest
smallest1039403s_mallest
smeariest1138113smeariest
smelliest1136603smelliest
smoggiest1334463smoggiest
smokiest1437883smo_kiest
snakiest122110543s_nakiest
snarliest91810203snarliest
sneakiest13176833sneakiest
snobbiest1354963snobbiest
snoopiest11157063snoopiest
snootiest9178753snootiest
snooziest18175393snooziest
snottiest9167973snottiest
snoutiest9178253snoutiest
snowiest1138143sno_wiest
sodalist9311883sodali_st
soggiest102711643s_oggiest
solidest9310383s_o_lidest
sonsiest8313033s_onsiest
sootiest84016753s_ootiest
soppiest122511933s_oppiest
sorriest8413883s_orriest
soupiest102212913s_oupiest
spaciest122310893s_paciest
spongiest1237083spongiest
spookiest15156393spookiest
spooniest11178133spooniest
sportiest111711023sportiest
spottiest11177683spottiest
sprawliest1543573sprawliest
squalidest2043393squalidest
squalliest1944133squalliest
stagiest91613403s_tagiest
stalest73720173s_tal_est
stalkiest1347903s_talkiest
steadiest1038513steadiest
steamiest1138403steamiest
steeliest939643steeliest
stilliest939223stilliest
stockiest15207753stockiest
stodgiest1135653stodgiest
stolidest1046113sto_lidest
stoniest8413543sto_niest
stoolies8311083stoolies_
stormiest1137003stormiest
strawiest1237213strawiest
studliest1036573studliest
sugariest1038133sugariest
surliest82416913s_urliest
sweatiest1238413sweatiest
swirliest1236293swirliest
swooniest12176293swooniest
swoopiest14155383swoopiest
thorniest1236483thorniest
throatiest1344943throatiest
unholiest1246303unho_liest
vealiest112513203_vealiest
whirliest15216043whirliest
wooliest113011643_wooliest
woolliest1235853woolliest

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.1731032896.0
2DLD Change Limit1486411726.42023152.8
3Display Results1721720.0802150.0
 (SQL Overall)1786911726.67326778.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.