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

140 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
flocci133502(None) 
bocci113512712_bocci
cocci82812672_cocci
flaccid1544392flaccid
floc95922122flo_c_
flocced15365482flocced
floccing16306032floccing
flocculi1542372flocculi
floccus1443652floccus
flock144717422flo_ck
flocks154713532flocks
flocky18468422flocky
flocs105519232flo_cs
foci94521012f_o_ci
loci66126282_lo_ci
bloc85023273blo_c_
block134917843blo_ck
blocks144513943blocks
blocky17388353blocky
blocs95219653blo_cs
blotch13197143blotch
bocce114313113_bocce
boccia12338793_boccia
boccie123311453_boccie
boccis123911133_boccis
cloaca1037263cloaca
cloche134312373cloche
clock134917983clo_ck
clocks144916233clocks
clonic104914673clonic
coccic8298943_coccic
coccid102910743_coccid
croci95818133cro_ci
dolci84912603_dolci
farci105919313f_arci
felucca1442123felucca
flack144519413fl_ack
flacks154114533flacks
flacon1138633flacon
fleche14299303fleche
fleck148213593fl_eck
flecks154310803flecks
flecky18387653flecky
fleece11369903fleece
fleech14367343fleech
fleecy14266483fleecy
flench144010813flench
fletch14388193fletch
flic96223733fl_ic_
flick145017213fl_ick
flicks154512993flicks
flics105418363fl_ics
flinch144010103flinch
flitch14928173flitch
float85928573flo_at
floats96816253floats
floaty124210943floaty
floccose1543133floccose
floccule1542813floccule
flocked174510253flocked
flockier1745343flockier
flocking183410873flocking
floe76129773flo__e
floes85528143flo_es
flog85523893flo__g
flogs95919963flo_gs
flokati1443483flokati
flong95815683flo_ng
flongs105010493flongs
flood95215603flo_od
floods104511653floods
flooey123910173flooey
flooie93712153flooie
floor84215233flo_or
floors94112353floors
floosie10378933floosie
floosy12368153floosy
floozie19295463floozie
floozy21356613floozy
flop96925453flo__p
floppy1654873floppy
flops105920143flo_ps
flora85317103flo_ra
florae94713883florae
floral94313813floral
floras94715693floras
floret9321123floret
florid10311453florid
florin9312653florin
floruit1047293floruit
floss85118263flo_ss
flossie10337443flossie
flossy12517703flossy
flota85315643flo_ta
flotas94013003flotas
flounce1235413flounce
flouncy1543673flouncy
flour84916453flo_ur
flours94414053flours
floury12449573floury
flout86226203flo_ut
flouts94315273flouts
flow105924923flo__w
flowed133513763flowed
flower124815503flower
flown116213993flo_wn
flows115822363flo_ws
fluoric1245813fluoric
flysch1732893flysch
focal104917673f_ocal
focus105815883f_ocus
folacin1238053folacin
folic105319323folic_
force105324273f_orce
fracti1139963fracti
frock145314653fro_ck
frocks154111213frocks
frolic1149203frolic
fuci95720313f__uci
glochid1445263glochid
gnocchi1541923gnocchi
lichi104412953_lichi
loach105116363_loach
loca65527683_lo_ca
local74820273_local
loch95527133_lo_ch
lochia1158313_lochia
lochs106715513_lochs
lock106134363_lo_ck
locks115126923_locks
loco67030743_lo_co
locos75822603_locos
loculi8288253_loculi
locum94812173_locum
locus74819993_locus
logic88217833_logic
logoi69715943_logoi
loti46431843_lo_ti
lotic76420673_lotic
slouch11438523slouch

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 Filter1786911127160.796224486.2
2DLD Change Limit1127161405.70619753.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.54827289.4
 
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.