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 “flumes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
flumes11511973(None) 
blumes105917791blumes
flames114723691flames
flues84626921flu_es
flukes135114191flukes
flume106021171flume_
flumed124915261flumed
flumps135112501flumps
flutes95421781flutes
fluxes165212931fluxes
fumes105224701f_umes
glumes94516811glumes
plumes104318131plumes
almes75126542al_mes
alums75720602alum_s
blames105121862blames
blues75127042blu_es
blume95619892blume_
blumed114313642blumed
brumes106417072brumes
climes104720002climes
clues74623032clu_es
clumps1215314642clumps
eludes75417682eludes
elutes64020312elutes
fames105735922f_ames
fauces114916152fauces
fauves125610422fauves
femes105626222f_emes
femmes135410212femmes
flakes134118872flakes
flambes14419502flambes
flame105124442flame_
flamed124618972flamed
flamen115215992flamen
flamens124611062flamens
flamer114919122flamer
flamers124616362flamers
flams105125012flam_s
flanes94522422flanes
flares94521702flares
flaxes165015352flaxes
flees85828752fl_ees
flexes164512952flexes
flies85630712fl_ies
flites95122442flites
floes85528142fl_oes
flubs105515442flu_bs
flue75329852flu_e_
flued95021252flu_ed
fluffs11347782fluffs
fluids10349422fluids
fluke125016892fluke_
fluked145112092fluked
flukey16459812flukey
flump124614722flum_p
flumped15377712flumped
flunks13469862flunks
fluors94311372fluors
flus75626542flu__s
flushes134114142flushes
flute86823752flute_
fluted104917162fluted
fluter95316862fluter
fluters103713682fluters
flutey125212522flutey
fluxed17509672fluxed
fluyts12367152fluyts
flymen14387772flymen
flytes123911562flytes
formes114623712formes
frames115119862frames
frumps13479782frumps
fume96727632f_ume_
fumed116118822f_umed
fumer105918232f_umer
fumers113613382f_umers
fumet105630222f_umet
fumets114311812f_umets
fuses85628422f_uses
fuzes175120222f_uzes
glimes94717522glimes
glues65125682glu_es
glume85120462glume_
glums84621422glum_s
glutes74517672glutes
grumes94415552grumes
illumes9327672illumes
kluges11389572kluges
lames75445542_lames
limes75636502_limes
lubes74727992_lubes
luces75528432_luces
ludes65728852_ludes
lues45943552_lu_es
luges65928752_luges
lumas75622912_lumas
lumen75220902_lumen
lumens85013972_lumens
lumps95624982_lumps
lums65734242_lum_s
lunes55337772_lunes
lures56138532_lures
lutes55836662_lutes
luxes124921502_luxes
neumes83112622neumes
plumbs12459332plumbs
plume94819462plume_
plumed114412882plumed
plumps124612612plumps
plums94619952plum_s
pluses83618072pluses
relumes9612512relumes
slimes84722042slimes
slues54527172slu_es
slumps104313582slumps
slums74623432slum_s
spumes1021314882spumes
volumes12298232volumes

Search took 3 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 Filter178691825510.346516448.0
2DLD Change Limit825511192.15638289.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911192.54870129.9
 
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.