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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

399 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
platans9341312(None) 
platan83913691platan_
platane93112301platane
platanes102711881platanes
platens94213981platens
blatant9310672blatant
lagans75717782_lagans
latens64620212_latens
lauans65113532_lauans
paeans85118262p_aeans
pagans95717922p_agans
palatals1037772palatals
partans94418282partans
patens84820862p_atens
patins87528782p_atins
pavans115715592p_avans
plains85019592pla_ins
plans75731272pl__ans
plantains1147492plantains
plateaus1035532plateaus
platen84518202platen_
platers93924082platers
plates85432242plat_es
platies93722542platies
platina94413642platina
platinas103610312platinas
plating103823072plating
platings113611362platings
platoons1038682platoons
plats75531372plat__s
platys11459852plat_ys
playas114612282playa_s
plazas17409912plaza_s
plutons938342plutons
ratans63819372_ratans
alanins7315803alanins
alans55636173__alans
alates64833963alat_es
alations82518893alations
albatas938373albata_s
altars64518153al_tars
atamans9710433atamans
ataps76414833__ataps
atmans84413963__atmans
avatars1036443avatars
azans146516883__azans
balatas9311833balata_s
batons85519423_batons
blains84516373bla_ins
blatancy1543573blatancy
blats75132503blat__s
blazons1836163blazons
caftans12179443caftans
callans94518473callans
captans111612053captans
chazans21268123chazans
clachans1546413clachans
clamant11312433clamant
clans75031013cl__ans
claxons1635803claxons
claypans1543873claypans
cleans85817053cl_eans
cotans81317923_cotans
cratons94316033cratons
daltons8310403daltons
damans94715983_damans
dilatant948203dilatant
dilatants1044513dilatants
elains64919853ela_ins
elans55527753el__ans
elastins82111733elastins
elaters74420183elaters
elates65032363elat_es
elating83423083elating
elations83719123elations
flacons1238053flacons
flagons1137973flagons
flamens124611063flamens
flans85327973fl__ans
flatcaps1563403flatcaps
flatcars1344623flatcars
flatland1264963flatland
flatlands1364303flatlands
flats86429743flat__s
flattens11357483flattens
flatus94310783flat_us
flatways1744323flatways
flautas1036153flauta_s
flavins1338543flavins
flotas94013003flota_s
gelatins93414093gelatins
glans65125833gl__ans
gleans75014743gl_eans
glucans1045293glucans
glutens8437593glutens
glycans1344233glycans
gratins84119183gratins
hazans183411653_hazans
isatins7310773isatins
japans1539823_japans
jawans1657843_jawans
kaftans14185353kaftans
kalians11310183kalians
katas95922093_kata_s
klaxons1833263klaxons
lactams1136953_lactams
ladens74516233_ladens
lagan66520343_lagan_
lahars94013163_lahars
lallans74113533_lallans
lamas75532793_lama_s
lanais6316793_lanais
lantana739603_lantana
lantanas838263_lantanas
lapins84520683_lapins
lateens74210553_lateens
laten54328343_laten_
latent64124303_latent
latents75214313_latents
lathes95127493_lathes
lathis95516173_lathis
laths86022403_lat_hs
latina65621143_latina
latinas74416463_latinas
latino64120473_latino
latinos73613803_latinos
latkes104715873_latkes
lats45962703_lat__s
lattens75014673_lattens
lattes65324203_lattes
lattins74115483_lattins
lauan55216793_lauan_
lavas85422223_lava_s
lawns85215423_la_wns
layins93817653_layins
lazars153812393_lazars
leans55536253_l_eans
lemans85316393_lemans
ligans76817733_ligans
limans84816303_limans
litany939053_litany
litas54923773_lita_s
llamas888973llama_s
loans56026463_l_oans
logans76319063_logans
lorans65117603_lorans
lotahs9479873_lotahs
lotas55926303_lota_s
matins84527783_matins
naans55815253_na_ans
natant6318733_natant
neatens73310403neatens
octans81411143_octans
pacas96029403p_aca_s
paean77222723p_aean_
paeons83915523p_aeons
paesans93312693paesans
pagan86121163p_agan_
pains75138283p_a_ins
paisans93614753paisans
paladins11911003paladins
palais8420423p_alais
palapas11311493palapa_s
palatal9310153palata_l
palates93624933palat_es
palatine10316063palatine
palatines11313013palatines
palters94021683palters
pans65855723p___ans
papains11312363p_apains
papas94927493p_apa_s
papaws13419113p_apaws
parang93715513p_arang
parangs104314373p_arangs
paras76143043p_ara_s
parians93519733parians
partan83820563partan_
partons94620513partons
pastas85422873pasta_s
pataca10311193p_ataca
patacas11311003p_atacas
paten74827343p_aten_
patent84524923p_atent
patents94815203p_atents
paters84935823p_aters
pates76047893p_at_es
pathos115516693p_athos
paths105521383p_at_hs
patin76832853p_atin_
patina86022193p_atina
patinas96318523p_atinas
patine85328123p_atine
patines95225763p_atines
patios85221783p_atios
patois84319363p_atois
patrons93818103p_atrons
pats66460853p_at__s
pattens95414923pattens
pavan106518473p_avan_
pavane114113443p_avane
pavanes123612653p_avanes
pavins114919663p_avins
pawns108818133p_a_wns
peahens12307573peahens
peans75437643p__eans
peasant9314923peasant
peasants1038263peasants
peats76140193peat__s
pecans101515833p_ecans
pechans14810503pechans
pectens11189203pectens
pectins112315233pectins
pekans121710553p_ekans
pelicans1238093pelicans
pelotas9410723pelota_s
pelotons1038913pelotons
pentads1039523pentads
pentane9415743pentane
pentanes10316073pentanes
pertains102113413pertains
petals84719813p_etals
phaetons1345853phaetons
phalanx1945203phalanx
photons123814413photons
phytane1545443phytane
phytanes1645753phytanes
phytins15317893phytins
phytons15319063phytons
pians75126963p__ians
pietas84516503pieta_s
pinatas93711483pinata_s
pintano998993pintano
pintanos10107553pintanos
pintas85021393pinta_s
pistons93016373pistons
pitas77427673p_ita_s
pitmans11188743pitmans
pitons85319043p_itons
pittas86014523pitta_s
placard1236783placard
placards1345813placards
placate11312433placate
placates12311753placates
placers114515263placers
places104323703pla_ces
placets113911223placets
placing123815283placing
placks144414153pla_cks
plafond1344183plafond
plafonds1443273plafonds
plagal948573plaga_l
plages94520153pla_ges
plagues103311063plagues
plaices11411143plaices
plaids94312443pla_ids
plain74823303pla_in_
plaint85323203pla_int
plaints94012053plaints
plaiters103512633plaiters
plaiting113113513plaiting
plaitings12296243plaitings
plaits83816473pla_its
plan65833943pl__an_
planar84212713plana_r
planate9314573planate
plane74929143pl__ane
planers94517943planers
planes85028083pla_nes
planets93914083planets
planing103418253planing
plank115221143pl__ank
planks124116753pla_nks
planktons1543673planktons
plant75437113pl__ant
plantain1047903plantain
plantar9369993planta_r
planters102915323planters
planting113515383planting
plantings12348403plantings
plants84921803pla_nts
plaques18317893plaques
plashes124417393plashes
plasmas113010753plasmas
plasmins12199403plasmins
plasmons12217663plasmons
plasms103711333pla_sms
plasters103518133plasters
plastics122412323plastics
plastids11269203plastids
plastrons1147133plastrons
plat66048873plat___
plate74635113plat__e
plateau937403plateau
plateaux1742873plateaux
plated95225773plat_ed
plater84427693plat_er
platier93716293platier
platiest103216083platiest
platinic1237073platinic
platinous1146193platinous
platinum1245443platinum
platinums1343963platinums
platonic1238773platonic
platonism1397543platonism
platoon938953platoon
platted103614263platted
platter93917413platter
platters103415283platters
platting114813033platting
platy105021663plat__y
platypi1442753platypi
platypus1542353platypus
playa105812943playa__
playact1446553playact
playacts1543813playacts
playdays1742973playdays
players124313763players
playing133816093playing
playland1444573playland
playlands1543893playlands
playpens1534073playpens
plays106320773pl__ays
plaza164311063plaza__
pleads94613953pl_eads
pleas75627033pl_ea_s
pleasant1048323pleasant
pleaters103613783pleaters
pleating112916053pleating
pleats85218593pl_eats
pleiads1045223pleiads
pleons84213343pl_eons
pliant83918823pl_iant
plots75025673plot__s
plotzes18317693plotzes
plurals936913plurals
pluteus9326243pluteus
pluton838853pluton_
polarons1039863polarons
pontons93315553pontons
portals94015563portals
postals93716373postals
postins93721203postins
praams10459643pra_ams
prajnas1635453prajnas
praters94921643praters
prates84633163prat_es
prating103424453prating
prats76333393prat__s
prawns11509023pra_wns
prolans9314273prolans
proteans102811543proteans
protons93118003protons
ptisans9317363ptisans
pullmans1253933pullmans
puritans1037633puritans
putons83515153p_utons
pyrans11411063p_yrans
quartans1736283quartans
ratals64219583_ratals
ratan53722663_ratan_
ratany93411873_ratany
rattans73411953rattans
reatas64021013reata_s
rhatany1353693rhatany
riatas63915083riata_s
saltant7316773saltant
saltpans1034813saltpans
sarans64224433_sarans
satang75711563_satang
satangs8479713_satangs
satays94411683_satays
satins64930483_satins
seawans10379943seawans
seitans73312303seitans
sextans14349263sextans
shaitans1136403shaitans
shamans123610893shamans
slaters73123723slaters
slates64934063slat_es
slating83724653slating
slatings94011723slatings
slats55436903slat__s
slogans8407983slogans
splats84817303splat__s
statant7313123statant
statins73719773statins
sultans72411833sultans
suntans72111733suntans
tans46154813___tans
tarlatans944343tarlatans
tartans72615823tartans
tatars64619793_tatars
titans63414913_titans
trapans92812463trapans
ulamas8910453ulama_s
ulans54921303ul__ans
wataps11248683_wataps
witans93412933_witans
zeatins16311733zeatins

Search took 9 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273998.09616554.7
3Display Results3993990.1402850.0
 (SQL Overall)1786913998.38921300.6
 
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.