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

118 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
ameer7561898(None) 
ambeer104511601ambeer
amber94523211amber
ameers84015571ameers
emeer74815361emeer
abler75624312abler
adder75419592adder
adeem8311802adeem
after85719792after
agee56241492agee_
ager55935842a_ger
agger76420892agger
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
ajee115928232ajee_
akee85936812akee_
akees96119242akees
alder65421912alder
alee46652322alee_
almner85710722almner
alter54828502alter
ambeers11428922ambeers
ambers104519582ambers
ambery133811132ambery
ambler104916452ambler
ameba9312382ameba
amen66733152am_en
amend85717752amend
amender10349612amender
amens75624842amens
ament76036542ament
amercer1146372amercer
amie66339852amie_
amies76837692amies
amir65129752am_ir
ammeter1148392ammeter
amour75014852amour
amped104820512amped
ampere10514412ampere
ampler104313302ampler
amuser84712622amuser
anear55420322anear
anger66225872anger
apeek114711872apeek
aper66336232a_per
apter76120202apter
armer76924442armer
asker96418782asker
asper75520432asper
aster55434892aster
auger64922472auger
aver75931882a_ver
awee76336642awee_
beer65635992_beer
camber124418482camber
camper124722212camper
career85822242career
cheer105420382cheer
dammer114317932dammer
damner95213432damner
damper114117752damper
deer56739022_deer
ember95516802ember
emeers83314182emeers
emmer94314462emmer
fakeer13378742fakeer
fleer86020772fleer
freer86021242freer
gamer84928942gam_er
gamier93617932gamier
gammer1112318332gammer
hammer138120032hammer
hamper134518652hamper
jammer174014132jammer
jeer115426462_jeer
lamber104418492lamber
lamer75233702lam_er
laveer94110422laveer
leer46239352_leer
macer912126942macer
maker114127812maker
mammer94218862mammer
mamzer19459832mamzer
maser75029972maser
mater74438862mater
mazer165722422mazer
meed74934702_meed
meek105624832_meek
meet65350552_meet
mere67244442_mere
merer75126232_merer
meter75130322_meter
namer75622102nam_er
omber95316442omber
omer67028392om_er
pamper124316662pamper
peer66238352_peer
queer143712812queer
ramee74633852ramee_
ramees84620892ramees
rammer103519652rammer
seer45547042_seer
sheer84726892sheer
smear74416392smear
smeek114912352smeek
sneer54919952sneer
speer74623902speer
steer55423862steer
sweer84918572sweer
tamer75230102tam_er
tamper104618512tamper
umber94617592umber
vamper134212652vamper
veer76229572_veer
weer75535092_weer
yammer133713182yammer

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.0931921408.6
2DLD Change Limit538001181.67032215.6
3Display Results1181180.0333575.8
 (SQL Overall)1786911181.79699493.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.