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

278 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
biface135810(None) 
bifaces1448061bifaces
bice86235562bi__ce
binate8419772binate
bipack1636522bipack
boniface1543862boniface
brace95629272b_race
deface123113862deface
efface14366672efface
enface112510352enface
face96140122__face
reface113616352reface
uniface1236952uniface
vivace1436552vivace
abidance1346323abidance
ace59656833___ace
airfare1047243airfare
anlace82513923anlace
apace94718383_apace
babe86835823b__abe
baccae12119703baccae
bach116131393b__ach
back125535763b__ack
bade75140883b__ade
baffle14399873baffle
bake105637513b__ake
balance11510263balance
bale66353843b__ale
bane65250423b__ane
bare65460523b__are
base64847023b__ase
bate66552423b__ate
beach124623893b_each
became123213163became
befall114410643befall
before11410153before
begaze1838333begaze
behave14209013behave
belaced124112153belaced
bename103316073bename
berake124216083berake
berate84729023berate
betake124512703betake
beware11313713beware
biali73419073bi_ali
bialy105119323bi_aly
bias64738163bi_a_s
biased94012223bi_ased
biases84618433bi_ases
bible95119423bi_ble
bicarb1238543bicarb
bicep115413543bi__cep
bices95029963bi__ces
bicycle1643993bicycle
bide76041483bi__de
bifacial15105273bifacial
biff125026893bif__f
biffed15449883biffed
biffies152710853biffies
biffin14369103biffin
biffs134814413bif_fs
biffy164711133bif_fy
bifid11910703bif_id
biflex1834953biflex
bifocal1445373bifocal
bifold1237223bifold
biforate1346903biforate
biform1368123biform
bigamy1436343bigamy
bigeye1236643bigeye
biggie103810933biggie
bike106532603bi__ke
bikie113915883bi_kie
bilayer12347803bilayer
bile66147183bi__le
bilge87618913bi_lge
billie85019173billie
bima86723833bima__
bimah127013273bima_h
bimahs13508303bimahs
bimas95521743bima_s
binal75323823bina_l
binary11312223binary
bindle94516263bindle
bine66650863bi__ne
binge85125513bi_nge
binnacle12325633binnacle
binocle1136493binocle
binocs1039923binocs
biome94916993bi_ome
bipacks1745043bipacks
biplane1139033biplane
birch124914023bi_rch
birdie94013783birdie
bireme10310143bireme
birkie124110133birkie
birle75023633bi_rle
birse74517403bi_rse
bise66437103bi__se
bisect10312873bisect
bisque17257843bisque
bistate9313823bistate
bistre83815023bistre
bitable11312203bitable
bitch125017763bi_tch
bite66547003bi__te
bivalve1543593bivalve
bizarre1844103bizarre
bize155926293bi__ze
bizone1738603bizone
black134719073b_lack
blade85923333b_lade
blae66134643b_la_e
blame95625493b_lame
blare75826233b_lare
blase75524233b_lase
blate75933783b_late
blaze165520833b_laze
bleach133611403bleach
bocce114313113b_occe
bodice11711423bodice
boldface1662893boldface
bonaci10310963bonaci
bonifaces1643733bonifaces
boraces113716853boraces
borage93917013borage
borane84620213borane
borate85026153borate
bounce104014833bounce
braced115420603b_raced
bracer104620583b_racer
braces108427773b_races
brach126123303b_rach
bract96332723b_ract
brae65639113b_ra_e
brake116025343b_rake
brave104925503b_rave
braze165423453b_raze
breach134213723breach
brigade1136493brigade
brisance1245953brisance
broach133611113broach
bubale104014623bubale
bullace113410673bullace
butane8313653butane
byname13256363byname
catface1436763catface
cicale10314503cicale
cilice103213353cilice
dace76934923__dace
defaced142910973defaced
defacer132810363defacer
defaces133213403defaces
defame123212433defame
dice75841893di__ce
didact10711203didact
dilate73220693dilate
dogface1454053dogface
edifice1344933edifice
effaced16225573effaced
effacer15255413effacer
effaces15277273effaces
enfaced13218913enfaced
enfaces122110913enfaces
enlace82213233enlace
faced117727653__faced
facer105525053__facer
faces106439433__faces
facet106038523__facet
fact97142543__fact
fade85736343__fade
fake115534943__fake
fame95639393__fame
fane75343563__fane
farce104925323__farce
fare76354463__fare
fate75444283__fate
fave105532963__fave
faze165630043__faze
fiacre1137623fi_acre
fiance11310743fiance
fice95737113__fice
fierce11348913fierce
fife106027703fif__e
finale94116763finale
finance1238573finance
fixate1638733fixate
fyce126316833__fyce
giftee103512083giftee
glace87420153_glace
grace85124543_grace
grimace1255083grimace
hijack2233673hijack
ice56737243_i__ce
image81411293_image
inane52820343_inane
infare9313083infare
inlace82513043inlace
irade65618153_irade
irate55627983_irate
kinase104210653kinase
lace66848473__lace
liane54720663li_ane
lice66045063li__ce
life75433733lif__e
ligase7259913ligase
ligate72519253ligate
lilac7311073lilac_
lilacs837483lilacs
linac7315413linac_
linacs8310813linacs
linage7713403linage
lipase8239103lipase
mace87345783__mace
menace103216943menace
mice87442233mi__ce
milage93414123milage
minae75627723mina_e
mince95325233mi_nce
miracle1138843miracle
mirage92313653mirage
misact10316683misact
misate81222693misate
nice65534713ni__ce
nidate7313783nidate
niece74814503ni_ece
office1435693office
orifice1246343orifice
outface123011973outface
pace86345773__pace
palace104516913palace
peace95026083_peace
piaffe1494913piaffe
pice84641093pi__ce
piece96717993pi_ece
pierce104010393pierce
piffle14418233piffle
pikake11115803pikake
pinnace113510313pinnace
pipage1199143pipage
piracy1339473piracy
pirate82322883pirate
place94824613_place
pomace123111913pomace
preface14510923preface
race66746263__race
refaced133713573refaced
refaces123216743refaces
relace83122153relace
rice64942913ri__ce
rife74632323rif__e
riffle124210233riffle
rifle85518333rif_le
rivage1038843rivage
rubace10310173rubace
sice65545593si__ce
sifaka1353553sifaka
silage72715303silage
silane62718053silane
since75024173si_nce
solace83415823solace
space95325673_space
surface1238653surface
tace65342513__tace
tenace82715693tenace
tierce8339843tierce
tirade7311693tirade
tisane6311573tisane
trace75829613_trace
unifaces1346393unifaces
unlace82215173unlace
vice95732853vi__ce
visage1049083visage
vitae84217633vita_e
vivaces1536413vivaces
wife105228023wif__e
wince105220883wi_nce
yince105214253yi_nce

Search took 7 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 Limit1127162786.45317467.2
3Display Results2782780.0932989.2
 (SQL Overall)1786912786.68626726.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.