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

161 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
imbalm124632(None) 
embalm1236651embalm
imbalms1334551imbalms
balm85534202__balm
cimbalom1642442cimbalom
embalms1335332embalms
gimbal11228812gimbal_
gimbals12257822gimbals
imam81718332im_a_m
imaum9139642im_aum
imbalmed1543282imbalmed
imbalmer1443192imbalmer
imbark14347862imbark
impala10256932impala
impale102811662impale
malm85129972_m_alm
timbal102510752timbal_
timbale11248802timbale
timbals11239532timbals
ambage11510603ambage
ambari103012163ambari
ambary134010543ambary
amble95924643amb_le
bal56662723__bal_
bald76432903__bald
bale66353843__bale
balk105132223__balk
ball66043323__ball
balms95723923__balms
balmy125217473__balmy
bals66354043__bals
bam78560143__ba_m
barm86739603__barm
becalm1239203becalm
blam86131703__blam
bubal94218213bubal_
bubale104014623bubale
bubals103513843bubals
cabal95222153cabal_
cabala103516913cabala
cabals104020153cabals
calm85032363__calm
cembali13156043cembali
cembalo13145533cembalo
cimbaloms1741973cimbaloms
cobalt10317393cobalt
copalm125010813copalm
cymbal15236913cymbal_
cymbalom1942283cymbalom
cymbals16236143cymbals
embalmed1544253embalmed
embalmer1444063embalmer
embank14346553embank
embar94011603emba_r
embark14458523embark
embars103812883embars
embay123410603emba_y
embays131408333embays
emblem1237583emblem
emboli1037483emboli
emboly1336723emboly
empale102611263empale
fimble133611753fimb_le
gimbaled14104173gimbaled
gimmal11247513gimmal_
gimmals12225823gimmals
gumball1266833gumball
halm95834973__halm
ideal65716393ideal_
ideals75012503ideals
ihram10310183ihra_m
ileal56118083ileal_
ilial55317843ilial_
image81411293im_age
imago8118693im_ago
imams91511113im_ams
imaums10106303im_aums
imbalmers1543103imbalmers
imbalming1643723imbalming
imbarks15326613imbarks
imbed105013653imb_ed
imbeds11456743imbeds
imbibe1234703imbibe
imblaze2044323imblaze
imbody1434113imbody
imbosom1343713imbosom
imbrue1035153imbrue
imbue939483imb_ue
imbued1136173imbued
imbues1037983imbues
immane1038883immane
impact122310453impact
impair1036003impair
impalas11236953impalas
impaled12288503impaled
impaler11298393impaler
impales113311763impales
impark14287073impark
impart102715143impart
impawn1333263impawn
impel95711773impel_
impels10389523impels
imply124911843im_ply
inarm7314423i_narm
infall939403infall
inhale9411513inhale
inwall938343inwall
isba61310883isba__
isbas71010403isba_s
jumbal1758463jumbal_
jumbals18106533jumbals
kabala124011553kabala
limba95414983limba__
limbas105313203limba_s
limbate1139213limbate
maim85831483_m_aim
male66052293_m_ale
mall64639363_m_all
malms95021553_m_alms
malmy124816343_m_almy
malt66254803_m_alt
meal65643173_meal_
meals75933373_meals
mealy104422183_mealy
miasm91211093_miasm
mimbar1297493mimba_r
mimbars1397383mimbars
misaim10311853misaim
napalm1047263napalm
nimble103412943nimb_le
nimbly13388773nimb_ly
palm85331363__palm
pibal95217323pibal_
pibals103813083pibals
piebald1245503piebald
pinball1137933pinball
psalm949273_psalm
qabala17399193qabala
qualm163511183_qualm
realm75621623_realm
ribald9209293ribald
robalo838923robalo
sabal75422483sabal_
sabals84618863sabals
sambal105215183sambal_
sambals115213483sambals
small74016263sm_all
smalt74729333sm_alt
smarm95517603sm_arm
tambala1138023tambala
timbales12227843timbales
timbral11237193timbral_
tombal102311023tombal_
tubal75517203tubal_
tymbal13236823tymbal_
tymbals14265723tymbals
umbel93612843umbel_
umbels104510593umbels
umbral1038633umbral_
unbale83616403unbale
wimble133211923wimb_le

Search took 9 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 Filter1786911127160.250714764.0
2DLD Change Limit1127161618.00014089.5
3Display Results1611610.0931731.2
 (SQL Overall)1786911618.34321418.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.