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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
elains6491985(None) 
blains84516371blains
elain55324701elain_
elans55527751ela_ns
elfins94810941elfins
eloins65419381eloins
plains85019591plains
ains46158882__ains
alanins7315802alanins
alans55636172ala_ns
algins74816432algins
aloins65022202aloins
blain75421792blain_
brains85125472brains
cains75334302_cains
chains114819702chains
claims105211572claims
clans75031012cla_ns
delaine8314782delaine
delaines9312942delaines
detains83716092detains
drains73719402drains
earns55927562e_arns
eclairs935962eclairs
elan46734242ela_n_
eland65820392ela_nd
elands74914772elands
elapids1036502elapids
elapine9310672elapine
elastins82111732elastins
elates65032362elates
elating83423082elating
elations83719122elations
elfin84312462elfin_
elint55436472el_int
elints65816422el_ints
eloigns8425352eloigns
eloin55923202eloin_
emails84412342emails
eosins64419162eosins
etamins91511832etamins
explains1766442explains
flails94313002flails
flairs95711912flairs
flans85327972fla_ns
flavins1338542flavins
gains65729512_gains
gelatins93414092gelatins
glairs75211332glairs
glans65125832gla_ns
grains74223092grains
kains96125642_kains
kelvins14106562kelvins
laics76419252_laics
lain46146282_lain_
lairs55425872_lairs
lapins84520682_lapins
lawns85215422_lawns
layins93817652_layins
leans55536252lea_ns
learns65513742learns
levins94514652levins
lins47059052_l_ins
loins56728422_loins
mains75635102_mains
melanins10310382melanins
oleins6313522oleins
pains75138282_pains
plaids94312442plaids
plain74823302plain_
plaint85323202plaint
plaints94012052plaints
plaits83816472plaits
plans75731272pla_ns
rains55140232_rains
regains84316582regains
relaxins15248682relaxins
remains94117902remains
retains74522252retains
sains55639972_sains
slain54923572slain_
stains64923652stains
swains94513952swains
tains54936322_tains
trains64725342trains
twains95811182twains
ulans54921302ula_ns
wains86930862_wains
welkins1437172welkins

Search took 4 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.1101624463.6
2DLD Change Limit82551893.17026041.3
3Display Results89890.0631412.7
 (SQL Overall)178691893.34353452.3
 
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.