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

228 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
bifold123722(None) 
behold1247342behold
bield84614652bi_eld
biffed15449882biffed
bifid11910702bif_id
biform1368122biform
billfold1443152billfold
bipod104410822bipo_d
bold75432812b__old
enfold10137612enfold
fold86528942__fold
infold10128162infold
pinfold1336232pinfold
refold103812112refold
sixfold1842722sixfold
trifold1136242trifold
unfold10179702unfold
upfold12124952upfold
acold86214923_acold
afford1346493afford
afield1035953afield
ahold94714253_ahold
aioli5318313ai_oli
baffed154812173baffed
baffle14399873baffle
baffled16418063baffled
bald76432903b__ald
befall114410643befall
befell11428713befell
befog1159013befo_g
befogs1246453befogs
befool1137713befool
befooled1434803befooled
befools1236433befools
before11410153before
befoul1137253befoul
befouled1434683befouled
befouls1236053befouls
beheld1236413beheld
beholds1336423beholds
beyond1237073beyond
biali73419073bi_ali
bialy105119323bi_aly
biased94012223biased
bibbed104712343bibbed
bible95119423bi_ble
bicolor1145613bicolor
bicorn103610103bicorn
bid67751793bi___d
bided95424963bi_ded
bields94110003bi_elds
biface1358103biface
biff125026893bif__f
biffin14369103biffin
biffs134814413bif_fs
biffy164711133bif_fy
bifidly1684233bifidly
bifilar1244043bifilar
biflex1834953biflex
bifocal1445373bifocal
bifocaled1742463bifocaled
bifocals1543703bifocals
biforked1842873biforked
biformed1643693biformed
bigfoot1355993bigfoot
bigly114814753bi_gly
bigos85020013bigo_s
bigot84828323bigo_t
bigoted11258403bigoted
bigots95015133bigots
bijou1458793bijo_u
bijous1548043bijous
bijoux2253453bijoux
biked125320033bi_ked
bile66147183bi__le
bilged105513183bilged
bilk105824423bi__lk
bilked134012943bilked
bill67239943bi__ll
billed94224903billed
billfolds1542763billfolds
billon83713823billon
billow114111223billow
bills75632863bi_lls
billy105525363bi_lly
bilobed1235913bilobed
binal75323823binal_
bind76234513bi__nd
bindle94516263bindle
binged105920823binged
binned94414543binned
binocle1136493binocle
binocs1039923binocs
bio57846083bi_o__
biofilm1444333biofilm
biog76122323bi_o_g
biogs85016113bi_ogs
biome94916993bi_ome
biont7727163bi_ont
bios66335323bi_o_s
biosolid1144893biosolid
biota74516823bi_ota
biped104718833bi_ped
bipods11408593bipods
bipolar1145453bipolar
bird76128323bi__rd
birded104414303birded
birl65830473bi_rl_
birle75023633bi_rle
birled94416993birled
birls74023163bi_rls
biro66131213biro__
biros75325133biro_s
birred94713203birred
bison75716983biso_n
bisons83914373bisons
bitted94418483bitted
bizone1738603bizone
blindfold1661653blindfold
blond85618373b_lond
blood85319523b_lood
bod67055543b__o_d
boffed15369483boffed
boffola1543463boffola
bola66035563b__ola
bolds85825283b__olds
bole66448693b__ole
boll65634753b__oll
bolo65535953b__olo
bolt66254173b__olt
bond75334363b__ond
booed85127273b_ooed
bricole112810493bricole
broad84817693b_road
brood84620243b_rood
buboed113010003buboed
buffed154313143buffed
build84413353b_uild
byroad1236623byroad
byword1535053byword
cibol9512023cibol_
cibols1039523cibols
citola838393citola
citole8311503citole
cold77338773__cold
diol57329133di_ol_
diols65521013di_ols
dipole91112853dipole
eidola737683eidola
enfolds11136253enfolds
eyefold1443343eyefold
fanfold1485373fanfold
field95015323fi_eld
fifed125115973fif_ed
fiord94313343fi_ord
fivefold1852553fivefold
folds95221693__folds
folk116021543__folk
fond86330953__fond
food86830573__food
ford86835493__ford
gifted114510703gifted
gigolo836533gigolo
gild65526513gi__ld
gold65430163__gold
hold86235063__hold
idol56818633_idol_
idols65514133_idols
infolds11137023infolds
kinfolk1363603kinfolk
kobold1365963kobold
lifted104413523lifted
lipoid9411043lipoid
manifold1484943manifold
miffed15398713miffed
mild75330853mi__ld
milord999563milord
mold76034333__mold
nailfold1242303nailfold
nicol71113293nicol_
nicols8810243nicols
ninefold1243243ninefold
old47033463___old
onefold1144493onefold
oxford1763663oxford
piffle14418233piffle
piffled16366403piffled
pinfolds1445143pinfolds
pinole83218783pinole
refolds11298953refolds
remold93412973remold
resold73915363resold
retold73013753retold
ribald9209293ribald
rifely123710033rifely
riffed133811563riffed
riffle124210233riffle
riffled14338603riffled
rifle85518333rif_le
rifled104115003rifled
rifted104115313rifted
scold85414863_scold
sifted104313673sifted
sild55030583si__ld
siloed74615303siloed
sold54837413__sold
tenfold1145713tenfold
tiffed13368393tiffed
told56132203__told
tufoli933973tufoli
twofold1442283twofold
unfolds11146803unfolds
unfond10149113unfond
unmold9148313unmold
unsold71410513unsold
untold7149683untold
upfolds13133753upfolds
uphold12126903uphold
viol76523593vi_ol_
viola85915543vi_ola
viols86118103vi_ols
viroid10411523viroid
wield95213913wi_eld
wifed125117743wif_ed
wifely15429423wifely
wild85126513wi__ld
wold85429073__wold
yield9519693yi_eld

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.1401276364.3
2DLD Change Limit1127162285.67019879.4
3Display Results2282280.0633619.0
 (SQL Overall)1786912285.87330425.8
 
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.