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

143 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
fumer10591823(None) 
fume96727631fume_
fumed116118821fumed
fumers113613381fumers
fumes105224701fumes
fumet105630221fumet
fumier11310901fumier
aimer75926822aimer
armer76924442armer
auger64922472auger
bummer124014102bummer
bumper123714342bumper
buyer105013092buyer
comer95832692comer
cuber95222532cuber
cumber124016702cumber
cummer124414592cummer
curer75030752curer
cuter74728232cuter
dimer85625602dimer
dumber114414172dumber
dumper114615212dumper
duper85519002duper
emmer94314462emmer
facer105525052facer
fader94421512fader
faker124824592faker
fame95639392fame_
famed115928342famed
fames105735922fames
farer86733142farer
farmer115017372farmer
feme96130542feme_
femes105626222femes
femur1038682femur
fer66646122f__er
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
filmer114112402filmer
finer85431562finer
firer811229252firer
firmer114712442firmer
fiver116024942fiver
fixer154717832fixer
flamer114919122flamer
fleer86020772fleer
flier86023402flier
flume106021172flume_
flumed124915262flumed
flumes115119732flumes
fluter95316862fluter
flyer114916252flyer
foamer114714312foamer
former114221402former
fouler93614902fouler
foyer116416552foyer
framer114817442framer
freer86021242freer
frier85225842frier
fryer115913432fryer
fubar1039922fubar
fucker153414422fucker
fuel76824732fu_el
fueler94313932fueler
fuhrer1235032fuhrer
fuller94220382fuller
fulmar1137252fulmar
fumbler143610812fumbler
fumets114311812fumets
fumy127118582fum_y
funder104016082funder
funker133915762funker
funner93414102funner
fur66637322fu__r
furler93616402furler
furor8312392furor
fuse76429992fuse_
fused94820442fused
fusee86224582fusee
fusel85218492fusel
fuses85628422fuses
fusser94813772fusser
fuze166422372fuze_
fuzed185415252fuzed
fuzee175718882fuzee
fuzes175120222fuzes
gamer84928942gamer
gomer85220652gomer
gummer114615452gummer
homer105828452homer
huger94914872huger
humeri1138522humeri
hummer133615272hummer
humor101110512humor
humper134115882humper
jumper173612372jumper
lamer75233702lamer
luger65322082luger
lumber103817772lumber
lumen75220902lumen
lumper103816652lumper
lurer54625312lurer
mimer94825762mimer
mummer93614542mummer
mumper123513522mumper
muser76024122muser
muter74525542muter
namer75622102namer
nuder66416832nuder
number103913222number
numen74216792numen
omer67028392_omer
ormer75218372ormer
outer55633302outer
puler74826622puler
pumper124415552pumper
purer75127902purer
queer143712812queer
rimer75429242rimer
ruder65320542ruder
ruer46127562ru_er
ruler54923342ruler
rumen74419502rumen
rummer104715482rummer
rumor71011322rumor
suber74924502suber
suer45334032su_er
summer104017712summer
super74924482super
surer54833102surer
tamer75230102tamer
timer75626042timer
tuber75420682tuber
tumor71110692tumor
tuner56022682tuner
tuyer85414292tuyer
umber94617592_umber
user45023002_user
vomer105517382vomer

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001431.59333772.8
3Display Results1431430.0304766.7
 (SQL Overall)1786911431.94991683.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.