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

123 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
plains8501959(None) 
blains84516371blains
elains64919851elains
pains75138281p_ains
plaids94312441plaids
plain74823301plain_
plaint85323201plaint
plaints94012051plaints
plaits83816471plaits
plans75731271pla_ns
ains46158882__ains
alanins7315802alanins
alans55636172ala_ns
algins74816432algins
aloins65022202aloins
blain75421792blain_
brains85125472brains
cains75334302_cains
chains114819702chains
claims105211572claims
clans75031012cla_ns
drains73719402drains
elain55324702elain_
elans55527752ela_ns
elfins94810942elfins
eloins65419382eloins
explains1766442explains
flails94313002flails
flairs95711912flairs
flans85327972fla_ns
flavins1338542flavins
gains65729512_gains
glairs75211332glairs
glans65125832gla_ns
grains74223092grains
kains96125642_kains
laics76419252_laics
lain46146282_lain_
lairs55425872_lairs
lapins84520682_lapins
lawns85215422_lawns
layins93817652_layins
lins47059052_l_ins
loins56728422_loins
mains75635112_mains
oleins6313522oleins
paiks114719852p_aiks
pails75833062p_ails
pain65647242p_ain_
paint75443692p_aint
paints85921832p_aints
pairs75325832p_airs
paladins11911002paladins
palais8420422palai_s
paling93530132paling
palings103915822palings
pans65855732p_a_ns
papains11312362papains
patins87528782patins
pavins114919662pavins
pawns108818132p_awns
peans75437642pea_ns
peins76128062p_eins
pekins121812232pekins
pians75126962pia_ns
pins65558452p__ins
places104323702places
placing123815282placing
placks144414152placks
plages94520152plages
plaice10311552plaice
plaices11411142plaices
plaid85118302plai_d
plained103812232plained
plainer93811982plainer
plainest10313612plainest
plainly1236472plainly
plait75631572plai_t
plan65833942pla_n_
plane74929142pla_ne
planes85028082planes
planing103418252planing
planish12412052planish
plank115221142pla_nk
planks124116752planks
plant75437112pla_nt
plants84921802plants
plasmins12199412plasmins
plasms103711332plasms
platans93413122platans
platens94213982platens
plates85432242plates
platies93722542platies
platina94413642platina
platinas103610312platinas
plating103823072plating
platings113611362platings
plats75531372pla_ts
platys11459852platys
playas114612282playas
playing133816092playing
plays106320772pla_ys
plazas17409912plazas
pleons84213342pleons
pliant83918822pliant
plies74526512pl_ies
plink115219122pl_ink
plinks124913262pl_inks
plying124312082plying
prawns11509022prawns
purins83722652purins
pyins105815862p_yins
rains55140232_rains
sains55639972_sains
slain54923572slain_
sprains93013592sprains
stains64923652stains
swains94513952swains
tains54936322_tains
trains64725342trains
twains95811182twains
ulans54921302ula_ns
wains86930872_wains

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.343520965.0
2DLD Change Limit825511233.00027517.0
3Display Results1231230.0462673.9
 (SQL Overall)1786911233.38952726.8
 
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.