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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
imbalms133455(None) 
embalms1335331embalms
imbalm1246321imbalm_
balms95723922__balms
cimbaloms1741972cimbaloms
embalm1236652embalm_
gimbals12257822gimbal_s
imams91511112im_a_ms
imaums10106302im_aums
imbalmed1543292imbalmed
imbalmer1443192imbalmer
imbalmers1543102imbalmers
imbarks15326612imbarks
impalas11236952impalas
impales113311762impales
malms95021552_m_alms
timbales12227842timbales
timbals11239532timbal_s
alms65834923___alms
ambages1269623ambages
ambaris113112163ambaris
ambles105121863amb_les
balas76937213__balas
balds85524643__balds
bales76250083__bales
balks114926293__balks
balls76236413__balls
balm85534203__balm_
balmy125217473__balmy
bals66354043__bal_s
bams87044453__ba_ms
barms96128473__barms
becalms1335743becalms
blams95023853__blams
bubales113513343bubales
bubalis11359903bubalis
bubals103513843bubal_s
cabalas113516003cabalas
cabals104020153cabal_s
calms95222353__calms
cembalos14135163cembalos
cimbalom1642443cimbalom
cobalts1139203cobalts
copalms13367543copalms
cymbaloms2052063cymbaloms
cymbals16236143cymbal_s
embalmed1544263embalmed
embalmer1444063embalmer
embalmers1543773embalmers
embanks15295703embanks
embarks15337353embarks
embars103812883emba_rs
embays131408333emba_ys
emblems1335043emblems
embolus1135543embolus
empales112411433empales
fimbles143510663fimb_les
gimbal11228813gimbal__
gimbaled14104173gimbaled
gimmals12225823gimmal_s
gumballs1345313gumballs
halms105225213__halms
ideals75012503ideal_s
ihrams1137173ihra_ms
images91411463im_ages
imagos9117553im_agos
imam81718333im_a_m_
imaum9139643im_aum_
imbalming1643723imbalming
imbark14347863imba_rk
imbeds11456743imb_eds
imbibes1334693imbibes
imblaze2044323imblaze
imblazes2144723imblazes
imbosoms1443303imbosoms
imbrues1135503imbrues
imbues1037983imb_ues
impacts13266503impacts
impairs1135823impairs
impala10256943impal_a
impale102811663impal_e
impaled12288513impaled
impaler11298393impaler
impalers12226973impalers
imparks15276663imparks
imparts11298533imparts
impawns1433323impawns
impels10389523impel_s
inarms8410093i_narms
infalls1038943infalls
inhales10511863inhales
inwalls1037283inwalls
isbas71010403isba__s
jimjams1742073jimja_ms
jumbals18106533jumbal_s
kabalas133911063kabalas
limbas105313203limba__s
maims96321793_m_aims
males75049793_m_ales
malls76233433_m_alls
malm85129983_m_alm_
malmy124816343_m_almy
malts76331753_m_alts
meals75933383_meal_s
miasms1097383_miasms
mimbars1397383mimba_rs
misaims11310113misaims
napalms1144033napalms
palms94921753__palms
pibals103813083pibal_s
piebalds1344343piebalds
pinballs1246933pinballs
psalms1045673_psalms
qabalas18289503qabalas
qualms17317243_qualms
realms84913493_realms
ribalds10236673ribalds
robalos937683robalos
sabals84618863sabal_s
sambals115213483sambal_s
smalls84514123sm_alls
smalts85214893sm_alts
smarms105712533sm_arms
tambalas1237033tambalas
timbal102510753timbal__
timbale11248803timbal_e
tymbals14265723tymbal_s
umbels104510593umbel_s
umbles103817493umb_les
unbales92914863unbales
wimbles143010853wimb_les

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 Filter1786911340270.810220606.2
2DLD Change Limit1340271316.56320421.6
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.41924085.6
 
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.