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

301 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
mimbar129749(None) 
mimbars1397381mimbars
disbar938512disbar
embar94011602_embar
gimbal11228812gimbal
imbark14347862_imbark
limba95414982limba_
limbas105313202limbas
limber104316792limber
lumbar103610592lumbar
mamba116317522mamba_
mambas125716242mambas
member12258852member
mimer94825762mim_er
minibar11106132minibar
sambar103914162sambar
simar74920812sim_ar
timbal102510752timbal
timber104012682timber
aimer75926823aim_er
airbag956963airbag
ambari103012173_ambari
ambary134010543_ambary
amber94523213_amber
bar58070553___bar
bibber94613573bibber
bima86723833bim_a_
bimah127013273bim_ah
bimas95521743bim_as
bimbo114811873bimb_o
bimbos124610523bimbos
bombard1437333bombard
bombax1935753bombax
bomber125014653bomber
bulbar1039583bulbar
busbar1038453busbar
camber124418483camber
chimar133911473chim_ar
cigar8911803ci_gar
climber13449133climber
combat12316753combat
comber125118503comber
cumber124016703cumber
cymar125711263cym_ar
cymbal15236913cymbal
damar84117733dam_ar
dammar11438903dammar
darbar959953darbar
debar85517863_debar
dibber114614713dibber
dimer85625603dim_er
dimmer114112613dimmer
dinar66319893di_nar
disbars10310323disbars
dumber114414173dumber
durbar968723durbar
embark14458523_embark
embars103812883_embars
embay123410603_embay
ember95516803_ember
eyebar1135323eyebar
fiar76427333fi__ar
fibber134811933fibber
fiber104921133fi_ber
filar84819293fi_lar
fimble133611753fimble
fubar1039923_fubar
gamba106018513gamba_
gambas115817513gambas
gambir11509773gambir
gibber114112863gibber
giber85417703gi_ber
gimbals12257823gimbals
gimmal11247513gimmal
hilar85418143hi_lar
imam81718333_im_am
imbalm1246323_imbalm
imbarks15326613_imbarks
imbed105013653_imbed
imbue939483_imbue
impair1036003_impair
impark14287073_impark
impart102715143_impart
invar839513_invar
isba61310883_isba_
isbas71010403_isbas
isobar836143isobar
izar136616013_i_zar
jibber174111243jibber
jiber145115703ji_ber
jimper17389863jimper
jumbal1758463jumbal
kabar114815553_kabar
kbar106514653__kbar
kebar115113533_kebar
kilobar1344613kilobar
kitbag1334973kitbag
lamber104418493lamber
liar47229683li__ar
libber104414013libber
liber74723623li_ber
libra74712423li_bra
lidar6312723li_dar
lima65734133lim_a_
liman75921603lim_an
limas75627633lim_as
limb85429383limb__
limbate1139213limbate
limbed114513183limbed
limbers113614743limbers
limbi96513813limb_i
limbic12528743limbic
limbier11349113limbier
limbo95614813limb_o
limbos104712143limbos
limbs96118943limb_s
limbus105710383limbus
limby125714073limb_y
limier83518723limier
limmer104314793limmer
limner84112873limner
limpa97014463limpa_
limpas105513083limpas
limper104117853limper
linear65113343linear
lobar7313013_lobar
lumbars11289763lumbars
lumber103817773lumber
maar66025063__maar
mailbag1243923mailbag
maimer104514593maim_er
makar115614973m_akar
malar76424443m_alar
mama86231593mam_a_
mamas95930773mam_as
mambo115215743mamb_o
mambos125414493mambos
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammary1335993mammary
mammas94616403mammas
mammer94218863mammer
mamzer19459833mamzer
mar57965953__m_ar
marimba1354983marimba_
marimbas1444363marimbas
medlar93010463medlar
megabar1244503megabar
members13258603members
memoir1037213memoir
mib76946123mi_b__
mibs85330483mi_b_s
mica86428253mi_ca_
micas96823053mi_cas
micra96214973micra_
microbar1445893microbar
midair937993midair
midcap1336473midcap
midday13327503midday
midway15327153midway
midyear1343343midyear
mihrab1335523mihrab
mikra114610313mikra_
mikvah18143473mikvah
milder93818453milder
miler75733063mi_ler
milia72719573milia_
miliary1249463miliary
milker124814323milker
miller84625413miller
millibar1275353millibar
milpa92111403milpa_
milpas101710273milpas
milter84921233milter
mim76048423mim___
mime85736403mim__e
mimed105622733mim_ed
mimeo96018683mim_eo
mimeos104511543mimeos
mimers105520183mimers
mimes95732023mim_es
mimic111414323mim_ic
mimical1339233mimical
mimicry1643493mimicry
mimics1289363mimics
miming114317263miming
mimosa1036363mimosa
mimosas1136753mimosas
mina65136923mi_na_
minae75627723mi_nae
minas75434113mi_nas
mincer104017363mincer
minder94822503minder
miner76933543mi_ner
minibars1296553minibars
minicar11109313minicar
minor74920063mi_nor
minter84425103minter
minyan1138173minyan
mir57046773mi___r
mirier83918363mirier
mirker123712693mirker
mirror848003mirror
mirza16410443mirza_
mirzas1738183mirzas
misbias1139083misbias
miseat82925703miseat
miser75430403mi_ser
mishap1338863mishap
mishear1238393mishear
miskal123710263miskal
mislay113510683mislay
mismark1536703mismark
mispart111113773mispart
missal84314903missal
missay114112143missay
mister84728563mister
miter75734793mi_ter
mither114218563mither
mitier83620673mitier
mitral81314323mitral
mixer145017643mi_xer
mobber123613463mobber
molar75223093m_olar
momma85111053momma_
mommas94110653mommas
momser104011413momser
momzer19327553momzer
mortar83812043mortar
muggar10316443muggar
mumble123614343mumble
mumbler133510913mumbler
mumbly15319463mumbly
mummer93614543mummer
mumper123513523mumper
mylar105311533m_ylar
nimbi94910313nimb_i
nimble103412943nimble
nimbler11358063nimbler
nimbly13388773nimbly
nimbus10377283nimbus
numbat10312083numbat
number103913223number
omber95316443_omber
pibal95217323pi_bal
pilar75221503pi_lar
pillar8314023pillar
pima85428653pim_a_
pimas94725103pim_as
qindar16317173qindar
qintar15359143qintar
rebar75420193_rebar
ribber103515493ribber
rimer75429243rim_er
rimier83916273rimier
rimmer103516033rimmer
rumba93612513rumba_
rumbas102512013rumbas
samba95618773samba_
sambal105215183sambal
sambars115113843sambars
sambas104219263sambas
sambhar1444853sambhar
sambur10469503sambur
shmear1176933shmear
sidebar1045563sidebar
sima64730783sim_a_
simars84916933sim_ars
simas75727553sim_as
simian8811163simian
similar937853similar
simitar936733simitar
simmer104115353simmer
simper103616293simper
simular938673simular
sirdar7269103sirdar
sitar54820543si_tar
sizar145214993si_zar
smear74416393_smear
somber103714003somber
tambac122210243tambac
tambak14249263tambak
tambur10358713tambur
timbale11248803timbale
timbals11239533timbals
timbers113111853timbers
timbery14256893timbery
timbral11237193timbral
timbre10328633timbre
timer75626043tim_er
tombac12258883tombac
tombak14237753tombak
tombal102311023tombal
tymbal13236823tymbal
umber94617593_umber
umbra948513_umbra
unbar71913613_unbar
vicar10513863vi_car
wimble133211923wimble
wombat1339863wombat

Search took 6 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.1431249587.4
2DLD Change Limit1127163015.28021347.7
3Display Results3013010.0933236.6
 (SQL Overall)1786913015.51632395.0
 
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.