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

110 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
djins136845(None) 
dins56652041d_ins
djin12911631djin_
djinn1355631djinn
djinns1443131djinns
jins115635011_jins
adjoins1585982adjoins
ains46158882_ains
amins75534322amins
ayins85321612ayins
bins66548252_bins
brins75533972brins
cains75334302cains
chins105631462chins
coins75834552coins
dais57040702dai_s
damns84916922damns
dans56748152d_ans
darns66927892darns
dawns95916592dawns
deans66131392deans
deigns8389982deigns
deils65722862deils
dens55945072d_ens
dibs76233682d_ibs
dies55653522d_ies
difs86027322d_ifs
digs66036052d_igs
dims75435022d_ims
din46459462d_in_
dine55555332d_ine
dines66449152d_ines
ding66940952d_ing
dings76331402d_ings
dink97137802d_ink
dinks105927952d_inks
dino56036752d_ino
dinos65428062d_inos
dint56759052d_int
dints67431312d_ints
dips75536912d_ips
dis46459892d_i_s
diss56434482d_iss
dits56450522d_its
djinni1442372djinni
djinny1732872djinny
doing74923582doing
doings84913182doings
doits66223672doits
dons56048702d_ons
downs94918572downs
drains73719402drains
dribs85115062dribs
dries64733672dries
drink106816382drink
drinks116810712drinks
drips85417232drips
duits65021882duits
duns55140432d_uns
durns64819862durns
dwine95616142dwine
dwines105013102dwines
dying105316032dying
dyings11478132dyings
fins75849092_fins
foins85523382foins
gains65729512gains
gins55543952_gins
grins65427222grins
hins76447992_hins
ins35945602__ins
jibs136724082_jibs
jigs126524762_jigs
jin106443932_jin_
jink156227202_jink
jinks165019332_jinks
jinn115420242_jinn
jinns126013842_jinns
jinx185516572_jinx
joins125818412joins
kains96125642kains
kins85747902_kins
lins47059052_lins
loins56728422loins
mains75635112mains
pains75138282pains
peins76128062peins
pins65558452_pins
pyins105815862pyins
quins144819852quins
rains55140232rains
reins56234562reins
rins46153192_rins
ruins55822032ruins
sains55639972sains
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
tains54936322tains
thins85826332thins
tins45251302_tins
twins85118982twins
veins84620492veins
wains86930872wains
whins114922332whins
wins75949172_wins
yins75335122_yins
zeins144715392zeins
zins135735002_zins

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.296603685.8
2DLD Change Limit538001101.34639970.3
3Display Results1101100.0303666.7
 (SQL Overall)1786911101.672106872.6
 
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.