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

305 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
firriest11231043(None) 
fieriest112112241fieriest
furriest112910791furriest
airiest74221012ai_riest
burriest102911212burriest
dirtiest93014202dirtiest
ferniest1132214152ferniest
ferries103521082ferries_
fiercest13216142fiercest
filmiest1338552filmiest
finniest113011402finniest
firmest1239272fi_rmest
firrier103410132firrie_r
fishiest14310452fishiest
fizziest19226072fizziest
flirtiest1236192flirtiest
forkiest153812302forkiest
furziest20267782furziest
girliest93010402girliest
merriest10311472merriest
miriest93619822mi_riest
mirkiest142910252mirkiest
sorriest8413882sorriest
tarriest83215002tarriest
wiriest103816852wi_riest
aeriest73924053_aeriest
airest63825263ai_r_est
angriest9310253angriest
arrest63722633_arr_est
artiest73121993_artiest
barkiest144115153barkiest
barmiest125212783barmiest
barniest104815053barniest
beeriest104013403beeriest
berries94423553berries_
bilgiest11309883bilgiest
birdies104016213birdies_
birkies133712433birkies_
bitsiest102610063bitsiest
bittiest103012043bittiest
blurriest1155153blurriest
briniest102812323briniest
burliest103113063burliest
carries94328013carries_
chariest13315503chariest
charriest1438253charriest
chirpiest16286473chirpiest
corkiest143114793corkiest
corniest102117303corniest
corries94026793corries_
curdiest112511393curdiest
curliest102713123curliest
curries93723163curries_
curviest13309673curviest
derries83124623derries_
diaries83321953diaries_
diarist8517113diari_st
diciest103316523di_ciest
dickiest153412503dickiest
dictiest113212783dictiest
dingiest102915373dingiest
dinkiest133812873dinkiest
dippiest132511133dippiest
direst75024243di_r_est
dirties83119383dirties_
dishiest12313683dishiest
ditsiest92111323ditsiest
ditziest18218473ditziest
dizziest17266723dizziest
dorkiest133111253dorkiest
driest74722753__driest
durries83817353durries_
earliest82415243earliest
eeriest73620673_eeriest
faddiest1338113faddiest
faeries104118993faeries_
faggiest132910183faggiest
fairest10412293fair_est
fairies103516043fairies_
fanciest133612713fanciest
farcies125317883farcies_
farrier103514893farrie_r
farriers113610743farriers
farriery14295403farriery
farthest1499863farthest
fattiest113514313fattiest
fawniest14287443fawniest
feistiest1237073feistiest
fenniest113113203fenniest
ferlies103216693ferlies_
ferninst11238313ferninst
ferret93021173ferr_e_t
ferrets103111393ferr_ets
ferried113411523ferrie_d
ferrites112312833ferrites_
fibres114312123fibr_es_
fibrils1236843fibrils_
fibrins1238633fibrins_
ficklest17267903ficklest
fideist1139753fidei_st
fierier103511193fierie_r
fieriness1238623fieriness
fifties132111083fifties_
fillies103420253fillies_
filthiest1545373filthiest
fineries112416743fineries_
finest94321733fi__nest
fireless112810593fireless
fires85740753fi_r_es_
firkins1437663firkins_
firmness1334743firmness
first86226123fi_r__st
fittest102510803fi_ttest
flakiest153210543flakiest
flamiest133111973flamiest
flawiest14298573flawiest
flaxiest18298183flaxiest
fliest94718433f__liest
flimsiest1434463flimsiest
flintiest1248433flintiest
florist10314243flori_st
flukiest15248063flukiest
flurries11188913flurries_
flutiest112610883flutiest
foamiest13289853foamiest
foggiest13249653foggiest
folkiest15319503folkiest
footiest113514913footiest
forest94926743f_or_est
forrit91916623forri__t
forties104323863forties_
foxiest174310493f_oxiest
foziest194110943f_oziest
frailest1139493f_railest
freest95318283f__reest
friaries11310083friaries_
fries85535603f__ries_
frilliest1237113frilliest
fringiest1347603fringiest
friskiest1636233friskiest
frizziest20294143frizziest
fubsiest13258413fubsiest
fuggiest13228813fuggiest
fumiest12312193f_umiest
funkiest152810973funkiest
funniest113010733funniest
furies95126373f_uries_
furrier103513663furrie_r
furriers11369493furriers
furriery14395683furriery
furriness12287603furriness
furthest1496863furthest
fussiest112910493fussiest
fustiest113014573fustiest
fuzziest19235793fuzziest
germiest11249913germiest
giddiest11298553giddiest
gimpiest1338473gimpiest
ginniest92610513ginniest
girlies83013703girlies_
glariest92012523glariest
goriest82218743_goriest
gorsiest92511133gorsiest
grimiest11299823grimiest
gripiest11289633gripiest
gurries83515953gurries_
hairiest11612463hairiest
hardiest123416333hardiest
harries103525493harries_
herbiest1339993herbiest
herries104025073herries_
hilliest113914113hilliest
hinkiest153311753hinkiest
hippiest152611613hippiest
hissiest112911093hissiest
hoariest11312883hoariest
horniest112814043horniest
horridest1345643horridest
horsiest112513263horsiest
hurries103919653hurries_
iciest82914743_i_ciest
ickiest133611043_ickiest
iffiest1337963_iffiest
inkiest113415043_inkiest
iratest7312483_iratest
jerkiest19328113jerkiest
jerries143817513jerries_
jiggiest17277693jiggiest
jiviest1738113ji_viest
kerries113317913kerries_
kickiest13319673kickiest
kinkiest113110503kinkiest
lardiest93813883lardiest
larkiest123713313larkiest
leariest83117843leariest
leeriest83112883leeriest
limbiest12258893limbiest
limiest93716103li_miest
lingiest93715263lingiest
liniest73321153li_niest
lintiest82715913lintiest
lippiest122310613lippiest
lorries74518343lorries_
marliest102415183marliest
marries93825283marries_
miffiest1637133miffiest
milkiest142911083milkiest
miltiest103015173miltiest
minciest122913103minciest
mingiest113315823mingiest
mintiest103217143mintiest
mirkest13309723mi_rkest
mistiest103018313mistiest
mitiest93520053mi_tiest
mooriest102812723mooriest
murkiest143210263murkiest
murries94118673murries_
nerdiest92511163nerdiest
nerviest11188833nerviest
niftiest112910073niftiest
nippiest12279973nippiest
nittiest82712603nittiest
oiliest72817683oi_liest
oneriest8313443oneriest
orbiest9312413_orbiest
parries93925843parries_
perkiest143313243perkiest
perries93226603perries_
pickiest162712593pickiest
piggiest12259663piggiest
piniest93121133pi_niest
pipiest113114493pi_piest
pithiest132711443pithiest
porkiest143513713porkiest
porniest103214313porniest
priciest122112903priciest
priest84125423__priest
priviest132310313priviest
pursiest102812123pursiest
purtiest102414113purtiest
quirkiest2234373quirkiest
ribbiest1237583ribbiest
ridgiest1038903ridgiest
rimiest93215853ri_miest
riskiest12310133riskiest
ritziest17237843ritziest
sarkiest123615063sarkiest
scariest101615943scariest
scarriest11188393scarriest
serries73925353serries_
shirtiest1239323shirtiest
silkiest123212853silkiest
silliest84017103silliest
siltiest83515613siltiest
sirrees73410573sirrees_
sirupiest1154753sirupiest
sissiest83412353sissiest
siziest16311473si_ziest
smirkiest1535193smirkiest
sparriest11198783sparriest
spiriest102513453spiriest
spriest92718643_spriest
starriest9159763starriest
surfiest112414433surfiest
surliest82416913surliest
swirliest1236293swirliest
tardiest93515243tardiest
tarries73324263tarries_
tartiest82718313tartiest
teariest82417263teariest
terries73425633terries_
tidiest83514873ti_diest
tiniest73020123ti_niest
tinniest82911463tinniest
tippiest122310013tippiest
tipsiest10228953tipsiest
tiredest938403tiredest
torridest1045753torridest
turfiest112410133turfiest
twirliest1234503twirliest
veriest103719133_veriest
viewiest1435853viewiest
viniest103216613vi_niest
wariest105122503_wariest
wartiest113614643wartiest
weariest112914793weariest
whirliest15216043whirliest
whirries14136693whirries_
wiftiest14279173wiftiest
wiggiest13269013wiggiest
wiliest103416593wi_liest
wimpiest1538763wimpiest
windiest122213233windiest
wingiest123214283wingiest
winiest103419693wi_niest
wintriest1238153wintriest
wispiest1339513wispiest
withiest142411243withiest
wittiest112711523wittiest
wordiest122311543wordiest
wormiest13249543wormiest
worries104117133worries_
wriest94419713__wriest
zingiest182810893zingiest
zippiest21248093zippiest

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623056.40622816.4
3Display Results3053050.1232479.7
 (SQL Overall)1786913056.95225703.5
 
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.