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

112 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
blains8451637(None) 
blain75421791blain_
brains85125471brains
elains64919851elains
plains85019591plains
ablins8316192abl_ins
ains46158892__ains
alanins7315802alanins
alans55636172ala_ns
algins74816432algins
aloins65022202aloins
baaing94916162baaing
bails75933522b_ails
bairns86710872b_airns
baits76630582b_aits
baling94829692baling
banns75321232b_anns
bans66555142b_a_ns
barns76335142b_arns
basins85722762basins
beans75734692bea_ns
begins94415302begins
bins66548262b__ins
blabs95619632bla_bs
blacks144914952blacks
blades95221252blades
blading113615362blading
bladings12337752bladings
blaffs14426622blaffs
blahs105616512bla_hs
blames105121862blames
blaming123515692blaming
blams95023852bla_ms
bland85320452bla_nd
blank115418552bla_nk
blanks124112892blanks
blares85021632blares
blaring104317112blaring
blasts85116772blasts
blats75132502bla_ts
blawing134012752blawing
blawn106813702blawn_
blaws105620462bla_ws
blazes174817352blazes
blazing193612392blazing
blazons1836162blazons
blin67228172bl_in_
blind86319322bl_ind
blinds95111612bl_inds
blini75519272bl_ini
blinis85313682bl_inis
blink115720142bl_ink
blinks124613572bl_inks
blips95615782bl_ips
bliss75616912bl_iss
bluing94914482bluing
bluings10327962bluings
braids95015692braids
brails84621292brails
brain76229382brain_
brainy114815642brainy
brans75437432bra_ns
brawns115614082brawns
brins75533972b_rins
bruins86014952bruins
burins84221892burins
cains75334302_cains
chains114819702chains
claims105211572claims
clans75031012cla_ns
drains73719402drains
elain55324702elain_
elans55527752ela_ns
elfins94810942elfins
eloins65419382eloins
flails94313002flails
flairs95711912flairs
flans85327972fla_ns
flavins1338542flavins
gains65729512_gains
glairs75211332glairs
glans65125832gla_ns
grains74223092grains
kains96125652_kains
laics76419252_laics
lain46146282_lain_
lairs55425872_lairs
lapins84520682_lapins
lawns85215422_lawns
layins93817652_layins
lins47059062_l_ins
loins56728422_loins
mains75635112_mains
obtains939162obtains
oleins6313522oleins
pains75138282_pains
plaids94312442plaids
plain74823302plain_
plaint85323202plaint
plaints94012062plaints
plaits83816472plaits
plans75731272pla_ns
rains55140232_rains
sains55639972_sains
slain54923572slain_
stains64923652stains
swains94513952swains
tains54936322_tains
trains64725342trains
twains95811182twains
ulans54921302ula_ns
wains86930872_wains

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 Filter178691825510.343520965.0
2DLD Change Limit825511125.51614965.7
3Display Results1121120.0303733.3
 (SQL Overall)1786911125.88930343.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.