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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
emeer7481536(None) 
ameer75618981ameer
ember95516801ember
emeers83314181emeers
emmer94314461emmer
ambeer104511602ambeer
amber94523212amber
ameers84015572ameers
beer65635992_beer
cheer105420382cheer
deer56739022_deer
eager65526972eager
eater54639842eater
edger75215952edger
eger55923572e_ger
egger74414412egger
eider64624742eider
elder64020022elder
elmier839812elmier
elver85216242elver
embar94011602embar
embed105014302embed
embers104116182embers
emcee9315942emcee
emceed1136282emceed
emcees1037812emcees
eme55837182em_e_
emend86214892emend
emender10649842emender
emery104814332emery
emes65434662em_es
emeses86114962emeses
emeu66723432em_eu
emeus76913332emeus
emir65918702em_ir
emmers104013222emmers
emmet94221382emmet
emoter85415192emoter
empery1348682empery
ender64325862ender
enter54726382enter
epee64628502epee_
epees75219832epees
esker94412982esker
ester54727712ester
ether84518772ether
evener91010622evener
ever77027692e_ver
ewer77523982e_wer
eyer76127282e_yer
fleer86020772fleer
freer86021242freer
hemmer134112642hemmer
jeer115426462_jeer
leer46239352_leer
meed74934702_meed
meek105624832_meek
meeker12359982meeker
meet65350552_meet
meeter83616502meeter
member12258852member
mere67244442_mere
merer75126232merer
meter75130322meter
omber95316442omber
omer67028392om_er
peer66238352_peer
queer143712812queer
remeet86325472remeet
seemer84418042seemer
seer45547042_seer
sheer84726892sheer
smear74416392smear
smeek114912352smeek
sneer54919952sneer
speer74623902speer
steer55423862steer
sweer84918572sweer
teemer85515742teemer
temper103914092temper
umber94617592umber
veer76229572_veer
veneer94511692veneer
weer75535092_weer

Search took 5 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.313570897.8
2DLD Change Limit53800843.25016553.8
3Display Results84840.0302800.0
 (SQL Overall)178691843.59349733.1
 
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.