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

149 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
flossie1033744(None) 
floosie10378931floosie
flossier11326971flossier
flossies112810121flossies
flooie93712152flo_oie
floosies113210232floosies
floozie19295462floozie
floss85118262floss__
flossed11388532flossed
flosser10339692flosser
flosses103411972flosses
flossiest12296802flossiest
flossily1434522flossily
flossing12247902flossing
flossy12517702floss_y
footsie1047652footsie
fossae95510372f_ossae
fosse86119462f_oss_e
fossil9379352f_ossil
glassie8329492glassie
glossae8477282glossae
glossier9358202glossier
glossies93311252glossies
lassie64917742_lassie
prossie91812952prossie
blastie92411393blastie
blooie83913193blo_oie
blossom11114963blossom
blouse84714723blous_e
blousier1055663blousier
blowsier1335063blowsier
bolshie1247123bolshie
bossier93712423_bossier
bossies94116833_bossies
brassie93411523brassie
classic113710113classic
classier10359083classier
classis93712723classis
close76425223clo_s_e
closure9278483closure
colossi935673colossi_
cosie74728263_co_sie
crosse85216303cross_e
crosstie1046933crosstie
dassie74615573_dassie
donsie7613643_donsie
dossier83711693_dossier
dossil75110903_dossil
drossier956313drossier
falsie93513853f_alsie
fesse86116333f_ess_e
filose96112503filo_s_e
fissile10269653f_issile
flashier1437103flashier
flense938903flens_e
fleshier1435603fleshier
flimsier1344133flimsier
flimsies1335783flimsies
floatier1136983floatier
flocci1335023flocci_
flockier1745343flockier
flocs105519233flocs__
floe76129773flo___e
floes85528143floes__
flogs95919963flogs__
floosy12368153floos_y
floozies20326953floozies
floppier1554633floppier
floppies1546813floppies
flops105920143flops__
florae94713883flo_rae
florid10311453flo_rid
florin9312653flo_rin
florist10314243florist
floruit1047293floruit
flossers11307863flossers
flotage1136683flotage
flotsam1244623flotsam
flounce1235413flounce
flowage1435723flowage
flows115822363flows__
flunkie1434513flunkie
fogie96719003f_o_gie
folkie13369613f_olkie
folksier1533533folksier
foodie104413843f_oodie
footie94718143f_ootie
footsies1139643footsies
foss76431643f_oss__
fossa85812633f_oss_a
fossas94610703f_ossas
fossate10388603f_ossate
fosses96022083f_osses
fossick16134733f_ossick
fossils10379013f_ossils
frostier1148163frostier
frowsier1444893frowsier
fussier103610673f_ussier
glassier9289083glassier
glassies94012273glassies
glassine9329313glassine
gloss64319623gloss__
glossa7529163gloss_a
glossal8447053glossal
glossas8438193glossas
glossed94410073glossed
glosseme1144023glosseme
glosser83410813glosser
glosses84014123glosses
glossiest10277943glossiest
glossily1235093glossily
glossina9275543glossina
glossing10278883glossing
glossy10549003gloss_y
gossip946433_gossip
gussie72910153_gussie
jalousie1543143jalousie
lassi56316853_lassi_
lassies74420103_lassies
lassis65216703_lassis
lessee64116363_lessee
loggie84011993_loggie
looie55624243_lo_oie
loonie64216453_loonie
loose56627683_loos_e
lose45144583_lo_s_e
loss45337963_loss__
losses65925233_losses
lossy85214643_loss_y
louie55023513_lo_uie
louse56131013_lous_e
lousier72411623_lousier
lowse87219903_lows_e
mossier94413813_mossier
ossia53710403__ossia
pliskie1394543pliskie
plisse8368403pliss_e
plosive1236673plosive
popsie103013053_popsie
posse74722273_poss_e
postie84123963_postie
potsie83916033_potsie
poussie936623poussie
prossies101515223prossies
prostie91617743prostie
sloshier1135283sloshier
sonsie6614863_sonsie
tassie66017023_tassie
tootsie737133tootsie

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271496.51320578.4
3Display Results1491490.0502980.0
 (SQL Overall)1786911496.96925640.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.