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

116 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
blain7542179(None) 
blains84516371blains
blawn106813701blawn
blin67228171bl_in
brain76229381brain
elain55324701elain
lain46146281_lain
plain74823301plain
slain54923571slain
again65218112again
ain37579092__ain
alan46844082ala_n
alanin6317272alanin
algin65718762algin
aloin55227412aloin
amain74922882amain
baaing94916162baaing
bail65042802b_ail
bairn77515532b_airn
bait66556002b_ait
baling94829692baling
ban58366832b_a_n
bani65334952b_ani
barn66444642b_arn
basin75026922basin
bean66443862bea_n
begin85117352begin
bin56658632b__in
blab86629132bla_b
blabs95619632blabs
black134719072black
blade85923332blade
blading113615362blading
blae66134642bla_e
blaff135216482blaff
blah98625062bla_h
blahs105616512blahs
blam86131702bla_m
blame95625492blame
blaming123515692blaming
blams95023852blams
bland85320452bland
blank115418552blank
blare75826232blare
blaring104317112blaring
blase75524232blase
blast76532572blast
blat66550952bla_t
blate75933782blate
blats75132502blats
blaw97026722bla_w
blawing134012752blawing
blaws105620462blaws
blaze165520832blaze
blazing193612392blazing
blazon1736762blazon
blind86319322bl_ind
blini75519272bl_ini
blink115720142bl_ink
blip88322772bl_ip
blown105716672blown
bluing94914482bluing
braid85822262braid
brail75525552brail
brains85125472brains
brainy114815642brainy
bran65740382bra_n
brawn106018562brawn
brin67038192b_rin
bruin75818332bruin
burin75626062burin
cain65643912_cain
chain105723672chain
claim95616912claim
clan65633922cla_n
drain65222892drain
elains64919852elains
elan46734242ela_n
elfin84312462elfin
eloin55923202eloin
fain75840562_fain
flail85316182flail
flair86114122flair
flan76134182fla_n
flavin1239302flavin
gain56042162_gain
glair65313552glair
grain65126252grain
kain85334292_kain
laic65931562_laic
laid56439142_laid
lair45934152_lair
lapin75222922_lapin
lawn75925632_lawn
layin84720332_layin
lin37967372_l_in
loin46838722_loin
main65345502_main
obtain839182obtain
olein5316002olein
pain65647242_pain
plaid85118302plaid
plains85019592plains
plaint85323202plaint
plait75631572plait
plan65833942pla_n
rain46251732_rain
sain45551292_sain
stain55727932stain
swain84919052swain
tain45548072_tain
train56529112train
twain86313622twain
ulan46527392ula_n
vain75233002_vain
wain75840192_wain

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 Filter178691538000.1101624463.6
2DLD Change Limit538001161.51335558.5
3Display Results1161160.0333515.2
 (SQL Overall)1786911161.656107905.2
 
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.