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

87 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
ember9551680(None) 
amber94523211amber
embar94011601embar
embed105014301embed
embers104116181embers
emeer74815361emeer
emmer94314461emmer
member12258851member
omber95316441omber
umber94617591umber
ambeer104511602ambeer
ambers104519582ambers
ambery133811132ambery
ambler104916452ambler
ameer75618982ameer
bomber125014652bomber
caber95126832caber
camber124418482camber
comber125118502comber
cuber95222532cuber
cumber124016702cumber
cyber124910382cyber
dumber114414172dumber
eager65526972eager
eater54639842eater
ebbed104111002ebbed
ebbet93517292ebbet
edger75215952edger
eger55923572e_ger
egger74414412egger
eider64624752eider
elder64020022elder
elmier839812elmier
elver85216242elver
embark14458522embark
embars103812882embars
embay123410602embay
embeds11377902embeds
emblem1237582emblem
embow1297562embow
embower14267412embower
emcee9315942emcee
eme55837182em_e_
emeers83314182emeers
emery104814332em_ery
emes65434662em_es
emeu66723432em_eu
emir65918702em_ir
emmers104013222emmers
emmet94221382emmet
emoter85415192emoter
empery1348682empery
ender64325862ender
enter54726382enter
esker94412982esker
ester54727712ester
ether84518772ether
ever77027692e_ver
ewer77523982e_wer
eyer76127282e_yer
fiber104921132fiber
giber85417702giber
hemmer134112642hemmer
imbed105013652imbed
jiber145115702jiber
lamber104418492lamber
liber74723622liber
limber104316792limber
lumber103817772lumber
members13258602members
merer75126232merer
meter75130322meter
number103913222number
ombers104214402ombers
ombre94111802ombre
omer67028392om_er
saber75330242saber
sober74822412sober
somber103714002somber
suber74924502suber
taber73825822taber
temper103914092temper
timber104012682timber
tuber75420682tuber
umbel93612842umbel
umbers104215212umbers
weber10313522weber

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 Filter178691538000.313570897.8
2DLD Change Limit53800871.72031279.1
3Display Results87870.0302900.0
 (SQL Overall)178691872.06386617.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.