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

206 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
flossies11281012(None) 
floosies113210231floosies
flosses103411971floss_es
flossie10337441flossie_
flossier11326971flossier
flossiest12296801flossiest
glossies93311251glossies
bossies94116832_bossies
flimsies1335782flimsies
floosie10378932floosie_
floozies20326952floozies
floppies1546812floppies
flossed11388532floss_ed
flosser10339692floss_er
flossers11307862flossers
flossily1434522flossily
flossing12247902flossing
footsies1139642footsies
fosses96022082f_oss_es
fossils10379012f_ossils
glassies94012272glassies
glosses84014122gloss_es
glossier9358202glossier
glossiest10277942glossiest
lassies74420102_lassies
losses65925232_loss_es
prossies101515222prossies
biopsies1237383biopsies
blasties102113623blasties
blesses93812393bless_es
blisses94911513bliss_es
bloodies11310163bloodies
blossoms12134543blossoms
blouses94014463blous_es
blousier1055663blousier
blousiest1136313blousiest
blowsier1335063blowsier
blowsiest1435323blowsiest
bolshies1338693bolshies
bosses85925403_boss_es
bossier93712423_bossier
bossiest103112213_bossiest
brassies103613533brassies
cissies94116153_cissies
classes94717943class_es
classics12418873classics
classier10359083classier
classiest11309543classiest
classis93712723classi_s
closes85425593clo_s_es
closures10228943closures
cosies84932153_co_sies
crosses94220793cross_es
crossties1139013crossties
dassies84418663_dassies
dosses76126273_doss_es
dossier83711693_dossier
dossiers9318043_dossiers
dossils8669773_dossils
dropsies1138693dropsies
droskies13186343droskies
drosses84513823dross_es
drossier956313drossier
drossiest1036523drossiest
enosises8311003enosises
falsies103515013f_alsies
felonies11310993felo_nies
felonries1246203felonries
fesses94820253f_ess_es
flashes133916103fl_ashes
flashier1437103flashier
flashiest1557983flashiest
flenses1039473flens_es
fleshes133913273fl_eshes
fleshier1435603fleshier
fleshiest1576223fleshiest
flies85630713fl___ies
flimsier1344133flimsier
flimsiest1434463flimsiest
floatier1136983floatier
floatiest1237283floatiest
flockier1745343flockier
flockiest1835643flockiest
floes85528143flo___es
flooie93712153flo_oie_
floozie19295453floozie_
floppier1554633floppier
floppiest1654773floppiest
florins10311643flo_rins
florists1138813florists
floruits1145153floruits
floss85118263flo_s__s
flossy12517703floss__y
flotages1237153flotages
flotsams1343383flotsams
flounces1335103flounces
flowages1535733flowages
flunkies1536393flunkies
flurries11188893flurries
flushes134114143fl_ushes
flysches1933123flysches
fogies104118063f_o_gies
folkies143612253f_olkies
folksier1533533folksier
folksiest1643983folksiest
follies103618943f_ollies
foodies113416753f_oodies
footies103721543f_ooties
footsie1047643footsie_
forties104323863f_orties
fossae95510373f_ossae_
fossas94610703f_oss_as
fosse86119463f_oss_e_
fossick16134733f_ossick
fossicks17134163f_ossicks
fossil9379353f_ossi_l
frasses104314513frass_es
frostier1148163frostier
frostiest1239213frostiest
frowsier1444893frowsier
frowsiest1535063frowsiest
fusses94920553f_uss_es
fussier103610673f_ussier
fussiest112910493f_ussiest
glasses84414273glass_es
glassie8329493glassie_
glassier9289083glassier
glassiest10279243glassiest
glassines10278043glassines
glories81915913glo_ries
glossae8477283glossae_
glossaries1144513glossaries
glossas8438193gloss_as
glossed94410073gloss_ed
glossemes1243783glossemes
glosser83410813gloss_er
glossers9319053glossers
glossily1235093glossily
glossina9275543glossina
glossinas10214143glossinas
glossiness11284983glossiness
glossing10278883glossing
glossitis10143593glossitis
gossips1035903_gossips
grosses84517683gross_es
gussies82813303_gussies
hissies103915823_hissies
hussies103213293_hussies
jalousies1643753jalousies
josses135117683_joss_es
lasses64827593_lass_es
lassie64917743_lassie_
lassis65216703_lassi_s
lassoes74613853_lassoes
lessees73510243_lessees
lobbies113612463_lobbies
loesses7310033_loesses
lollies73116923_lollies
longies82916553_longies
loobies93814103_loobies
looies65025833_lo_oies
loonies73919543_loonies
looses67328243_loos_es
lories64933043_lo_ries
lorises73918593_lorises
lorries74518343_lorries
loses56742013_lo_s_es
lossless835473_lossless
louies64525103_lo_uies
louses66230283_lous_es
lousier72411623_lousier
lousiest82311613_lousiest
missies93423983_missies
mosses85527683_moss_es
mossier94413813_mossier
mossiest103112443_mossiest
ologies8615023olo_gies
pliskies1475973pliskies
plisses94411773pliss_es
ploidies1138173ploidies
plosives1335893plosives
plotties103111413plotties
plusses93510693pluss_es
poesies93217403_poesies
popsies112816463_popsies
posies84431433_po_sies
posses85128803_poss_es
posties93128813_posties
potsies93019483_potsies
poussies1038113poussies
prissies101712003prissies
prosses94019513pross_es
prossie91812953prossie_
prosties101421193prosties
pussies93615693_pussies
sassies74719263_sassies
sissies73716603_sissies
sloshes103811803slo_shes
sloshier1135283sloshier
sloshiest1246673sloshiest
tassies74918933_tassies
tootsies848613tootsies
tosses65225393_toss_es
whosises1435333whosises
wussies103411083_wussies
zloties1639913zlo_ties

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.1731032896.0
2DLD Change Limit1461622066.89021213.6
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.14325016.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.