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

150 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
eyebar113532(None) 
eyebars1245331eyebars
debar85517862_debar
embar94011602e_mbar
eyeball1245062eyeball
eyebeam1443562eyebeam
eyer76127282eye__r
eyewear1342622eyewear
kebar115113532_kebar
rebar75420192_rebar
typebar1442992typebar
year76534252_ye_ar
alegar739283alegar
ameba9312383ameba_
amebae1049633amebae
ameban1039103ameban
amebas10311453amebas
anear55420323ane_ar
bar58070553___bar
bear66844643_be_ar
blear75918683ble_ar
bulbar1039583bulbar
busbar1038453busbar
byelaw1444253byelaw
caesar8410943caesar
cedar84014323_cedar
cerebra1155933cerebra
clear76219053cle_ar
cyber124910383cy_ber
cymar125711263cy_mar
cymbal15236913cymbal
darbar959963darbar
dear55343603_de_ar
debag94212303_debag
debark134210943_debark
debars94218043_debars
denar65223293_denar
dewar95817733_dewar
disbar938513disbar
drear65016903dre_ar
durbar968723durbar
dyer85522113dye__r
ear36867883__e_ar
edema8610553edema_
edemas9310503edemas
eger55923573ege__r
eggar7458883e_ggar
embark14458523e_mbark
embars103812883e_mbars
embay123410603e_mbay
ember95516803e_mber
emeer74815363eme_er
endear74110013endear
enema7612743enema_
enemas8812003enemas
escar74011993e_scar
eschar1136533eschar
eskar9457453e_skar
evener91010623evener
ever77027693eve__r
ewer77523983ewe__r
exedra1434503exedra
eyas76427433ey__as
eye65539773eye___
eyeable1239063eyeable
eyeballs1344213eyeballs
eyebeams1542133eyebeams
eyeblack19102733eyeblack
eyebolt1246363eyebolt
eyebrow1542873eyebrow
eyecup1344493eyecup
eyed86623233eye__d
eyeful1235903eyeful
eyeing10429363eyeing
eyelash1344563eyelash
eyelet9514533eyelet
eyelid1038443eyelid
eyen76223663eye__n
eyers86521333eye_rs
eyes75837883eye__s
eyesore1046173eyesore
eyewash1642583eyewash
eyewater1444243eyewater
eyra76217553ey_ra_
eyras84715923ey_ras
eyrir8359653ey_rir
fear75337793_fe_ar
feuar8310243_feuar
feyer115014523feye__r
fubar1039923_fubar
gear55934973_ge_ar
gleba83910243gleba_
glebae9407613glebae
hear76143883_he_ar
hyena11810253hyena_
hyenas1288953hyenas
hyetal1236543hyetal
isobar836143isobar
kabar114815563_kabar
kbar106514663__kbar
kebab134312003_kebab
kebars124112493_kebars
kyar116916853ky__ar
lear47045953_le_ar
lobar7313013_lobar
lumbar103610593lumbar
megabar1244503megabar
mimbar1297493mimbar
mylar105311533my_lar
near45236503_ne_ar
oyer75927653oye__r
pear69745233_pe_ar
prewar114712583prewar
rear45644553_re_ar
rebars84019833_rebars
redear73515173rede_ar
regear73512743rege_ar
rehear93713223rehe_ar
retear63115483rete_ar
rewear93012003rewe_ar
sambar103914163sambar
sear47353843_se_ar
sewar85421103_sewar
shear85424833she_ar
sidebar1045563sidebar
smear74416393sme_ar
spear75821063spe_ar
stelar64013863stelar
swear85316853swe_ar
tear45242883_te_ar
thenar92610003thenar
tyer75323393tye__r
tymbal13236823tymbal
typebars1542493typebars
unbar71913613_unbar
unbear889163unbear
upbear1096493upbear
velar85817633_velar
wear75836723_we_ar
weber10313523_weber
yar67253833_y__ar
yea66445753_ye_a_
yeah106725413_ye_ah
yean75834583_ye_an
yearn86316433_ye_arn
years84527673_ye_ars
yeas78638423_ye_as
yerba101010763yerba_
yerbas11119293yerbas
zebra1637883_zebra

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.376475242.0
2DLD Change Limit1127161505.20321663.7
3Display Results1501500.0305000.0
 (SQL Overall)1786911505.60931857.9
 
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.