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 “bisk” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

198 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
bisk10652335(None) 
bask105131421bask
bilk105824421bilk
birk106326861birk
bis56860661bis_
bise66437101bise
bisks115416801bisks
bosk105825731bosk
brisk115615981brisk
busk105429221busk
disk96625831disk
risk85724101risk
ais39083572ais_
ask77130702_ask
back125535762back
balk105132222balk
bank105835742bank
bark106242152bark
bas58681752bas_
base64847022base
bash915240162bash
basks115621762basks
bass66146782bass
bast66362412bast
beak106534382beak
beck126226572beck
berk105929842berk
bes56557432bes_
best66355322best
bi48046472bi__
bias64738162bias
bib77045942bi_b
bibb75819212bibb
bibs84830992bibs
bice86235562bice
bid67751792bi_d
bide76041482bide
bidi78226572bidi
bids75838432bids
bier65531832bier
biff125026892biff
big67345722bi_g
bigs76235022bigs
bike106532602bike
bile66147182bile
bilks115117892bilks
bill67239942bill
bima86723832bima
bin56658642bi_n
bind76234512bind
bine66650862bine
bins66548252bins
bint67355042bint
bio57846082bi_o
biog76122322biog
bios66335322bios
bird76128322bird
birks114920302birks
birl65830472birl
biro66131212biro
birr66022362birr
birse74517402birse
bises75435622bises
bison75716982bison
bit57070902bi_t
bite66547002bite
bits66148162bits
bitsy104511302bitsy
bitt65545812bitt
biz147939362bi_z
bize155926292bize
blink115720142blink
bliss75616912bliss
bock126032512bock
boink115516332boink
bonk105531712bonk
book106836332book
bork106933822bork
bos57966812bos_
bosh96328972bosh
bosks115218852bosks
bosky145612392bosky
boss65938342boss
brick134618152brick
brink116122002brink
bris65539612bris_
brisks124611402brisks
briss75824272briss
brusk114912432brusk
buck125129902buck
bulk105426152bulk
bunk105731352bunk
bus56950972bus_
bush96630712bush
busks115521372busks
buss65134912buss
bust65947782bust
busy94727172busy
bys85229462bys_
cask105626432cask
cis57748032cis_
cist67244962cist
cusk105521632cusk
desk95618902desk
dick116432382dick
dink97137802dink
dirk96326832dirk
dis46459892dis_
disc76123232disc
dish86328332dish
disks105417472disks
diss56434482diss
dusk95724152dusk
fink117532122fink
fisc96819752fisc
fish106926272fish
fist76248422fist
frisk125312372frisk
gink97129522gink
gist56046762gist
hick135530302hick
his66359502his_
hisn79620932hisn
hiss75629212hiss
hist76551542hist
husk116021952husk
ibis66519582ibis_
ick97329322_ick
ilk78325302_ilk
ink76433632_ink
irk76426362_irk
is27048212_is_
ism56322382_ism
jink156227202jink
jism135514772jism
kick96026062kick
kink76034392kink
kiosk836232kiosk
kirk76221562kirk
kis78051472kis_
kiss85227392kiss
kist86540792kist
lick106935072lick
link86943442link
lis37162272lis_
lisp68926872lisp
list47055342list
mask105227352mask
mick126333432mick
milk105028472milk
mink106636522mink
mirk106729502mirk
mis58162622mis_
mise66043582mise
miso67229902miso
miss65339422miss
mist66154532mist
mosk105622442mosk
musk104526192musk
nick106627602nick
nisi45823242nisi
obis66226842obis_
oink85429342oink
pick125933812pick
pink107039382pink
pis56362032pis_
pish96127912pish
piso66727562piso
piss65033332piss
qis126934382qis_
rick107334652rick
rink87736992rink
rise45945232rise
risks94917062risks
risky126311522risky
rusk85823312rusk
sick106435572sick
silk85529322silk
sink86640142sink
sis37360542sis_
task85326652task
tick106231222tick
tis37056642tis_
tsk75814732_tsk
tusk85621632tusk
vis66747612vis_
visa76323872visa
vise75632672vise
whisk154510142whisk
wick135726302wick
wink116435022wink
wis66552332wis_
wise75737342wise
wish107228732wish
wisp97124072wisp
wiss75630542wiss
wist78049292wist
xis106935332xis_

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit298721980.97030795.9
3Display Results1981980.0464304.3
 (SQL Overall)1786911981.079165608.0
 
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.