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

224 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
blin6722817(None) 
bin56658641b_in
blain75421791blain
blind86319321blind
blini75519271blini
blink115720141blink
blip88322771blip
brin67038191brin
lin37967371_lin
ablins8316192ablins
agin56132712agin
ain37579092_ain
akin86328032akin
alan46844082alan
algin65718762algin
alien56425582alien
alif76242142alif
align65016502align
aline57243152aline
alit46155692alit
aloin55227422aloin
amin66042252amin
ayin76331742ayin
bail65042802bail
bairn77515532bairn
bait66556002bait
baling94829692baling
ban58366842b_an
bani65334962bani
barn66444642barn
basin75026922basin
bean66443862bean
been65335782been
begin85117352begin
being84920502being
belie75630382belie
belon73924112belon
ben56554922b_en
berlin83116372berlin
bi48046472b_i_
bib77045942b_ib
bid67751812b_id
big67345722b_ig
bile66147182bile
bilk105824422bilk
bill67239942bill
bind76234512b_ind
bine66650862b_ine
bins66548252b_ins
bint67355042b_int
bio57846082b_io
bis56860662b_is
bit57070902b_it
biz147939362b_iz
blab86629132blab
blae66134642blae
blah98625062blah
blains84516372blains
blam86131702blam
bland85320452bland
blank115418552blank
blat66550952blat
blaw97026722blaw
blawn106813702blawn
bleb85425222bleb
bled75729312bled
blend85317452blend
blent76230952blent
blet66247672blet
blew94722432blew
blimp115612942blimp
blimy125212822blimy
blinds95111612blinds
blinis85313682blinis
blinks124613572blinks
blintz1788842blintz
blips95615782blips
bliss75616912bliss
blite76225352blite
blitz165318132blitz
blob86027092blob
bloc85023272bloc
blog75723822blog
blond85618372blond
blot65842322blot
blow95827192blow
blown105716672blown
blub85324872blub
blue65328462blue
bluing94914482bluing
blunt75525022blunt
blur66020532blur
boil66335182boil
boing84725552boing
boink115516332boink
boon67142172boon
born67338412born
brain76229382brain
bran65740382bran
bren65629562bren
brie65837902brie
brig76528032brig
brim85629372brim
brine75132272brine
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
brio65432492brio
bris65539612bris
brit66350152brit
bruin75818332bruin
bun56348142b_un
bunn65023652bunn
burin75626062burin
burn65636432burn
byline11311642byline
cain65643912cain
chin96934742chin
clan65633922clan
cline76428532cline
cling86424672cling
clink115320042clink
clip86924002clip
clon66232482clon
coin66645352coin
colin76231692colin
din46459462_din
djin12911632djin
elain55324702elain
elan46734242elan
elfin84312462elfin
elint55436472elint
eloin55923202eloin
fain75840562fain
fin66458032_fin
flan76134182flan
flic96223732flic
fling97023512fling
flint87333502flint
flip96324262flip
flir76422202flir
flit76539272flit
foin77231562foin
gain56042162gain
gin46055752_gin
glen56027202glen
glia56423152glia
glib79421442glib
glim76026352glim
glint66830182glint
goblin939502goblin
grin55733722grin
hin67559562_hin
ilia46026822ilia
in28150862__in
jin106443932_jin
join116724832join
kain85334292kain
kiln85620982kiln
kin76353972_kin
klik74412652klik
lain46146282lain
li29948752_li_
lib57750272_lib
lid47453522_lid
lie38264522_lie
lien45339802_lien
limn66527692_limn
line46965572_line
ling57447962_ling
link86943442_link
linn46034592_linn
lino46343372_lino
lins47059052_lins
lint416266232_lint
liny78141322_liny
lion46334442_lion
lip514755802_lip
lis37162272_lis
lit39377312_lit
loin46838722loin
main65345522main
olein5316002olein
olio46829672olio
pain65647242pain
pein65834942pein
pin57066722_pin
plain74823302plain
plan65833942plan
plie65127392plie
plink115219122plink
pyin96823232pyin
quin135823922quin
rain46251732rain
rein46040892rein
rin36663182_rin
ruin47430512ruin
sain45551292sain
shin75634312shin
sin36265892_sin
skin85927532skin
slain54923572slain
slid55828982slid
slim66631962slim
sling66028802sling
slink95422912slink
slip67031732slip
slit46250102slit
spin66231302spin
tain45548072tain
thin76732392thin
tin36362172_tin
twin76023082twin
tyin76424002tyin
ulan46527392ulan
vain75233002vain
vein75625752vein
wain75840202wain
whin105225692whin
win66456292_win
yin67648732_yin
zein135620602zein
zin125643772_zin

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.283631417.0
2DLD Change Limit298722240.87334217.6
3Display Results2242240.0464869.6
 (SQL Overall)1786912241.202148661.4
 
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.