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

239 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
biffin1436910(None) 
biffing163510011biffing
biffins15358531biffins
boffin14359051boffin
tiffin12327931tiffin
baffing164011602baffing
biff125026892biff__
biffed15449882biffed
biffies152710852biffies
biffs134814412biff_s
biffy164711132biff_y
bifid11910702bi_fid
biggin103710602biggin
biotin83215832biotin
boffing16339982boffing
boffins15329072boffins
bowfin14338352bowfin
buffi136112202buffi_
buffing163411392buffing
coffin14339812coffin
griffin1434512griffin
miffing16298402miffing
muffin14298872muffin
puffin141149002puffin
riffing144011272riffing
tiffing14339382tiffing
tiffins13327982tiffins
affine12310503_affine
affix1836003_affix
baff124632273baff__
baffed154812173baffed
baffies153612943baffies
baffle14399873baffle
baffling1756053baffling
baffs134718053baff_s
baffy165511923baff_y
barfing134615093barfing
basin75026923b_asin
beduin939713beduin
beefing133911473beefing
befit105222663b_efit
begin85117353b_egin
benzin1738933benzin
berlin83116373berlin
biali73419073biali_
bialis83617163bialis
biasing103512453biasing
bibbing11299613bibbing
bicorn103610103bicorn
bicron103710773bicron
bidden104010793bidden
bidding123613513bidding
bidi78226573bi_di_
biding104720793bi_ding
bidis86721143bi_dis
biface1358103biface
biflex1834953biflex
bifold1237223bifold
biform1368123biform
biggie103810933biggie
bigging122815883bigging
biggins113410693biggins
bigwig1333343bigwig
bikie113915883bi_kie
biking135018173bi_king
bikini12418913bi_kini
bilging114212683bilging
bilking144413553bilking
billie85019173billie
billing103823853billing
billion92212173billion
billon83713833billon
bin56658643b___in
bindi85617013bindi_
binding113819383binding
bindis94614583bindis
binging113619383binging
binit76431583bi_nit
binning103615453binning
biofilm1444333biofilm
biogen9310253biogen
bionic103614573bionic
biopic123710673biopic
biotic103816613biotic
biotins93114453biotins
birdie94013783birdie
birding114014923birding
birkie124110133birkie
birling104317053birling
birring103713063birring
bison75716983bi_son
biting95321823bi_ting
bitten84715123bitten
bitting103717293bitting
blain75421793b_lain
blin67228173b__lin
bluefin1245123bluefin
bluffing17275493bluffing
bobbin93410733bobbin
bodkin1338923bodkin
boff124727333boff__
boffed15369483boffed
boffo136010373boff_o
boffos14568193boffos
boffs134915503boff_s
boudin9412373boudin
bowfins15267703bowfins
brain76229383b_rain
briefing1436943briefing
brin67038193b__rin
bromin102615693bromin
brucin1049133brucin
bruin75818333b_ruin
buff125229863buff__
buffed154313143buffed
buffer144512683buffer
buffet143113783buffet
buffier1568403buffier
buffo135112183buff_o
buffoon1543713buffoon
buffos14447853buffos
buffs135519513buff_s
buffy165013373buff_y
bumkin14308083bumkin
burin75626063b_urin
buskin123811493buskin
caffein1535333caffein
chiffon1844053chiffon
citrin82615413citrin
coffing163811253coffing
coffins153110193coffins
coiffing1755933coiffing
cuffing163210253cuffing
daffing15369733daffing
diamin9312523diamin
diazin1639163diazin
diff116228843diff__
differ133910843differ
diffs126315483diff_s
dioxin14118783dioxin
doffing15357793doffing
elfin84312463_elfin
fain75840563__fain
fibrin1138533fibrin
ficin103516723fi_cin
fifing134212343fi_fing
fin66458033___fin
firkin1337823firkin
foin77231563__foin
gaffing15379733gaffing
gifting123810893gifting
gittin72910553gittin
griffins1544783griffins
griffon1443103griffon
haffit1538533haffit
huffing17278833huffing
iff96730393_iff__
iffier1236763_iffier
iffy135312283_iff_y
infix15337773_infix
iodin64419353_iodin
jiff175321413jiff__
jiffies20327473jiffies
jiffs185710313jiff_s
jiffy21458313jiff_y
kaffir16345303kaffir
kinin94917323ki_nin
lifting113313273lifting
lignin74911193lignin
linin58025523li_nin
lipin75518893li_pin
luffing143310103luffing
maffia14327203maffia
miff125625063miff__
miffed15398713miffed
miffier1537023miffier
miffs134512883miff_s
miffy163910203miff_y
mirin75023153mi_rin
misfit112813833misfit
muffing163210403muffing
muffins15308343muffins
naffing14359033naffing
niacin8310223niacin
niffer12378443niffer
offing13368643_offing
olefin937583olefin
piaffing1733923piaffing
pidgin10259813pidgin
piffle14418233piffle
piffling1745133piffling
piggin103111093piggin
pinyin112710613pinyin
pipkin14248603pipkin
pippin92810303pippin
puffing162910943puffing
puffins15278913puffins
raffia12287703raffia
redfin10310223redfin
reffing143712173reffing
ricin74620213ri_cin
riff104430103riff__
riffed133811563riffed
riffle124210233riffle
riffling1556113riffling
riffs115114613riff_s
rifling112815013rifling
riflip1134723riflip
rifting113515003rifting
ruffian1344133ruffian
ruffing143210843ruffing
sifting113014593sifting
simlin8311733simlin
siskin1079783siskin
sniffing15227453sniffing
soffit1237883soffit
spiffing17237083spiffing
stiffen13286023stiffen
stiffie13245773stiffie
stiffing15248703stiffing
suffix1935233suffix
taffia12286903taffia
tailfin1035693tailfin
tiepin839343tiepin
tiff104727723tiff__
tiffany1642663tiffany
tiffed13368393tiffed
tiffined1543403tiffined
tiffs114414883tiff_s
violin9311983violin
virgin1038083virgin
waffie15338563waffie
waffing173710243waffing
whiffing2134703whiffing
wifing133513393wi_fing
wimmin1336153wimmin
within123611383within
yaffing17337823yaffing
zaffir21395513zaffir

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.393454684.5
2DLD Change Limit1127162395.50020493.8
3Display Results2392390.0763144.7
 (SQL Overall)1786912395.96929936.5
 
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.