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

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

55 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
imbalmer144319(None) 
embalmer1444061embalmer
imbalmed1543291imbalmed
imbalmers1543101imbalmers
embalmed1544262embalmed
embalmers1543772embalmers
imbalm1246322imbalm__
imbalms1334552imbalm_s
impaler11298392impal_er
ambler104916453amb_l_er
balder95318863__balder
baler75635273__bal_er
balker124519163__balker
baller83825203__baller
balmier113811513__balmier
blamer104417143__blamer
calmer105216933__calmer
cymbaleer1841753cymbaleer
cymbaler1743113cymbal_er
embalm1236653embalm__
embalms1335333embalm_s
emblazer2144563emblazer
empaler11288353empal_er
gimbaled14104173gimbal_ed
gimballed1542673gimballed
imager9108123im_a_ger
imbalming1643723imbalming
imbarked17254063imbarked
imbiber1333593imb_iber
imbitter12265283imbitter
imblaze2044323imblaze_
imblazed2243763imblazed
imblazes2144723imblazes
imbolden1353263imbolden
imbower14235663imb_ower
impacter14296573impacter
impairer1244863impairer
impale102811663impal_e_
impaled12288513impal_ed
impalers12226973impal_ers
impales113311763impal_es
imparter12357543imparter
impeller1236083impeller
inflamer1356123inflamer
inhaler1068053inhal_er
maimer104514593_m_aimer
malmier113611953_m_almier
mammer94218863_m_ammer
mealier93015903_mealier
misalter1038343misalter
nimbler11358063nimb_l_er
palmer105816543__palmer
smaller93410333sm_aller
timbale11248803timbal_e_
timbales12227843timbal_es

Search took 8 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 Filter1786911461620.1531167915.0
2DLD Change Limit146162557.00020880.3
3Display Results55550.0163437.5
 (SQL Overall)178691557.16924925.5
 
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.