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

161 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
florists113881(None) 
florist10314241florist_
amorists10411332amorists
aorists74215832_aorists
colorists112313592colorists
flavorists1643522flavorists
florets1039852flor_ets
florins10311642flori_ns
floristic1447162floristic
floristry1542712floristry
floruits1145152floruits
flutists11256412flutists
foists95413982f_o_ists
forests104114952f_orests
forints10411832f_orints
lorises73918592_lorises
lyrists1036962_lyrists
ologists939442ologists
afforests1543733afforests
agonists9289833agonists
alarmists1145943alarmists
algorisms1246173algorisms
altoists848753altoists
altruists945413altruists
amorist9317643amorist_
aorist64827873_aorist_
aphorists1448263aphorists
arborists1147453arborists
atomists102610963atomists
aurists74615783_aurists
blurbists1343273blurbists
cladists1136723cladists
clonisms1237793clonisms
colonists112512503colonists
colorisms132810793colorisms
colorist102818993colorist_
czarists1966223czarists
diarists9410363diarists
egoists887073ego_ists
egotists937063egotists
elegists9128113elegists
elitists848543elitists
eulogists1046653eulogists
exorcists1845043exorcists
faddists13235543faddists
fascists1336613fascists
fauvists1443843fauvists
feists94915313f__eists
feudists1244463feudists
fideists1245543fideists
firsts95110923f_ir_sts
fists85527543f___ists
flautists1253683flautists
flavorist1545453flavorist_
flints95617453fl__ints
flirts95411483fl__irts
flits85625223fl__i_ts
floats96816253flo__ats
floorings13245093floorings
floosies113210233floosies
florals104210063flor_als
floras94715693flor__as
floret9321123flor_et_
floriated1347023floriated
florid10311453flori__d
floridity1644233floridity
floridly1554593floridly
florigen12154633florigen
florigens13133863florigens
florin9312653flori__n
floristries1452873floristries
floruit1047293floruit_
floss85118263flo__s_s
flosses103411973flo_sses
flossies112810123flossies
flourish1446753flouris_h
flourishes1644293flourishes
flouts94315273flo__uts
fluorides1345823fluorides
fluorids1245493fluori_ds
fluorines1247553fluorines
fluorins1137343fluori_ns
fluorite1147893fluori_te
fluorites1257163fluorites
fluoroses1244943fluoroses
fluorosis1243923fluorosis
flutist102910783flutist_
flypasts1662433flypasts
foist85730973f_o_ist_
folklorists18111773folklorists
footrests12244503footrests
forest94926743f_orest_
forgets113813793f_orgets
forint9325023f_orint_
formats123113573f_ormats
forts86034453f_or__ts
frises94124273f__rises
frisks13479263f__risks
frits86129103f__ri_ts
fritts94613193f__ritts
frosts94214623f__rosts
frowsts13426103fro_wsts
fuguists1243693fuguists
futurists1245583futurists
glorias81610323glori_as
glories81915913glori_es
glorious946823glorious
glosts74513813glo__sts
gnomists1145473gnomists
grists74716483__grists
hoists95516023_ho_ists
holists104413963_holists
hornists11208833_hornists
horsts95817513_hor_sts
humorists1445783humorists
ironists839293ironists
joists134711033_jo_ists
jurists14409123_jurists
lariats7615053_lariats
legists899593_legists
lists56628693_l__ists
locusts9277933_locusts
lookists1245713lookists
lories64933043_lori_es
loris55329153_lori__s
lutists73810273_lutists
lyrisms1235653_lyrisms
lyrist9312293_lyrist_
meliorists1245983meliorists
melodists1246633melodists
metrists1039853metrists
monists93614783_monists
motorists1149913motorists
oboists937903obo_ists
odists749853__odists
ologist8313833ologist_
olorosos844113olorosos
oologists1039853oologists
plenists1038253plenists
pollists10910823pollists
poloists10910523poloists
porisms113713453_porisms
protists10313363protists
purists94014073_purists
querists1736543querists
rigorists1045673rigorists
sacrists1039563sacrists
soloists869153soloists
tenorists948193tenorists
theorists1246603theorists
tourists838313tourists
tsarists857303tsarists
tzarists1755693tzarists
ufologists1445423ufologists
ultraists947333ultraists
utopists1045773utopists
valorises122210183valorises
verists103613673_verists
violists1137663violists
worsts96014333_wor_sts
wrists95415643__wrists

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 Filter1786911461620.466383457.1
2DLD Change Limit1461621616.90621164.5
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.43524033.8
 
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.