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

257 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
florist1031424(None) 
florists1138811florists
amorist9317642amorist
aorist64827872_aorist
colorist102818992colorist
flavorist1545452flavorist
floras94715692floras_
floret9321122flor_et
florets1039852florets
florid10311452flori_d
florin9312652flori_n
florins10311642florins
floristic1447162floristic
floristry1542712floristry
floruit1047292floruit
floruits1145152floruits
flourish1446752flourish
flutist102910782flutist
foist85730972f_o_ist
forest94926742f_orest
forint9325022f_orint
loris55329152_loris_
lyrist9312292_lyrist
ologist8313832ologist
afforest1446343afforest
agonist82615403agonist
alarmist1049123alarmist
algorism1147353algorism
alist56136783al__ist
altoist7313393altoist
altruist857953altruist
amorists10411333amorists
aorists74215833_aorists
aphorist13412513aphorist
arborist10411613arborist
atomist92915763atomist
aurist65027253_aurist
blowiest1337923blowiest
blurbist1245493blurbist
boorish123712593boorish
cladist10311973cladist
clerisy1246823clerisy
clonism1138983clonism
closest94312533closest
colonist102617933colonist
colorism122112433colorism
colorists112313593colorists
czarist18710223czarist
diarist8517113diarist
egoist7612283ego_ist
egotist8411273egotist
elegist81311973elegist
elitist7414913elitist
eulogist949043eulogist
exorcist1746873exorcist
faddist12289643faddist
fairest10412293fairest
fairish1338993fairish
fascist1239213fascist
fauvist1336663fauvist
feist86230073f__eist
feudist1137573feudist
fideist1139753fideist
fieriest112112243fieriest
fiords10498623fiords_
firriest112310433firriest
first86226123f_ir_st
fist76248423f___ist
fjords17405353fjords_
flairs95711913flairs_
flakiest153210553flakiest
flamiest133111983flamiest
flares94521703flares_
flaring114116803flaring
flautist1186803flautist
flavorists1643523flavorists
flawiest14298583flawiest
flaxiest18298193flaxiest
flemish1536373flemish
fliest94718433fl_iest
flint87333503fl__int
flirs85518933flir_s_
flirt87424753fl__irt
flirtiest1236193flirtiest
flirts95411483flirts_
flit76539273fl__i_t
flits85625223fl__its
float85928573flo__at
floatiest1237293floatiest
floats96816253floats_
flockiest1835643flockiest
flocks154713533flocks_
flocs105519233flo_cs_
floes85528143flo_es_
flogs95919963flo_gs_
flongs105010493flongs_
floods104511653floods_
flooie93712153flooi_e
flooring12259883flooring
floors94112353floors_
floosie10378933floosie
floosy12368153flo_osy
floppiest1654783floppiest
flops105920143flo_ps_
flora85317103flor__a
florae94713883flor_ae
floral94313813flor_al
florals104210063florals
floriated1347023floriated
floridity1644233floridity
floridly1554593floridly
florigen12154633florigen
floss85118263flo__ss
flossie10337443flossie
flossiest12296803flossiest
flossy12517703flo_ssy
flotas94013003flotas_
flouring123010143flouring
flours94414053flours_
flout86226203flo__ut
flouts94315273flouts_
floweriest1644533floweriest
flowing143411763flowing
flows115822363flo_ws_
fluish1239333fl_uish
flukiest15248063flukiest
fluoric1245813fluori_c
fluorid1136783fluori_d
fluoride1245873fluoride
fluorids1245493fluorids
fluorin1037233fluori_n
fluorine1147813fluorine
fluorins1137343fluorins
fluorite1147893fluorite
fluors94311373fluor_s_
flutiest112610883flutiest
flutists11256413flutists
flypast1583753flypast
foists95413983f_o_ists
folkiest15319503folkiest
folkish1736563folkish
folklorist1782603folklorist
follis93113903follis_
foolish1339613foolish
footiest113514913footiest
footrest11308853footrest
forbs105720803f_orbs_
fords95328183f_ords_
fores85847103f_ores_
forests104114953f_orests
forgat104018583f_orgat
forget106326393f_orget
forgot104318133f_orgot
forints10411833f_orints
forkiest153812303f_orkiest
forks125324683f_orks_
format113021353f_ormat
forms105327053f_orms_
forrit91916623f_orrit
fort76456443f_or__t
fortis95418613f_ortis_
forts86034453f_orts_
foxiest174310493f_oxiest
foziest194110943f_oziest
frise85322453f__rise
frisk125312373f__risk
frit77044473f__ri_t
frits86129103f__rits
fritt86129413f__ritt
frost84727833f__rost
frowst125512073fro_wst
fuguist1136073fuguist
furriest112910793furriest
futurist1148283futurist
glariest92012533glariest
gloria71910553glori_a
glorias81610323glorias
gloried9169523gloried
glories81915923glories
glorify1444583glorify
glost65422933glo__st
gnomist1049133gnomist
goriest82218743_goriest
grist65529873__grist
hoist86433213_ho_ist
holist94723213_holist
hornist102314823_hornist
horst85833513_hor_st
humorist1348783humorist
ironist7314843ironist
joist125125653_jo_ist
jurist134616393_jurist
lariat6629043_lariat
laris54737463_laris_
legist71315253_legist
list47055343_l__ist
locust85312343_locust
logiest82515543_logiest
lookist1139563lookist
lords64923503_lords_
lores55045403_lores_
lorica8310443_lorica
lories64933043_lories
lorises73918593_lorises
lost47951493_lo__st
louis57322323_louis_
lowest93915593_lowest
lowish12310533_lowish
lutist64317553_lutist
lyrism1137473_lyrism
lyrists1036963_lyrists
meliorist1148463meliorist
melodist1149743melodist
metrist9317063metrist
moist76033583_mo_ist
monist84324983_monist
mooriest102812723mooriest
moorish123311783moorish
motorist10314413motorist
noris54928273_noris_
oboist8312683obo_ist
odist6421913__odist
ologists939443ologists
oloroso744613oloroso
oologist9313493oologist
plenist9314333plenist
pollist9816603pollist
poloist91016323poloist
poorest9312773poorest
pooris83916843pooris_
poorish123712303poorish
porism104518063_porism
protist9320223protist
purist85525053_purist
querist16311133querist
rigorist949123rigorist
sacrist9315423sacrist
slowest10168713slowest
slowish1337633slowish
soloist7915893soloist
sorest65028003_sorest
tenorist8413023tenorist
theorist1149553theorist
tourist7313203tourist
tsarist7712253tsarist
tsoris63411193tsoris_
tzarist1659103tzarist
ufologist1347053ufologist
ultraist849633ultraist
utopist938693utopist
valorise112110313valorise
verist93823893_verist
violist10312143violist
whorish1636603whorish
worst86330133_wor_st
wrist84827563__wrist
zoris145320013_zoris_

Search took 8 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 Limit1340272576.53020524.8
3Display Results2572570.0932763.4
 (SQL Overall)1786912577.02925422.0
 
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.