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

232 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
platanes10271188(None) 
platane93112301platane_
platans93413121platan_s
palatines11313032palatines
patines95225762p_atines
pavanes123612652p_avanes
pentanes10316082pentanes
phytanes1645762phytanes
placates12311752placates
planes85028082pl__anes
platan83913692platan__
platens94213982platen_s
plates85432242plat__es
platies93722542plat_ies
platinas103610312platinas
platings113611362platings
alanines8314803alanines
alates64833963alat__es
alkanes113812933al_kanes
anatases839793anatases
atones65225773__atones
blatancies1444373blatancies
blatancy1543573blatancy
blatant9310673blatan_t
butanes9312743_butanes
cetanes9315133_cetanes
dilatants1044513dilatants
elastases946113elastases
elates65032363elat__es
elatives1139783elatives
flamines13311643flamines
flanes94522423fl__anes
flatlands1364303flatlands
flatlines12268433flatlines
flatmates1446193flatmates
flatness1138153flat_ness
flattens11357483flattens
flatuses1137173flatuses
flatwares1544763flatwares
flavines1437893flavines
flavones1435833flavones
fleabanes1443553fleabanes
floatages1344233floatages
flotages1237163flotages
gelatines102910533gelatines
heptanes1339003heptanes
isatines8310663isatines
klatches17157133klatches
lactases1038513_lactases
lactates10311223_lactates
lactones10311223_lactones
lacunes9159623_lacunes
lagans75717783_lagan_s
lagunes8148523_lagunes
laitances1145613_laitances
lanes54946793_l__anes
lantanas838263_lantanas
lasagnes944783_lasagnes
latches123320123_latches
lateens74210553_lateens
latened8711923_latened
lateness82614073_lateness
latens64620213_laten_s
latents75214313_latents
latexes1438313_latexes
lathes95127493_lat_hes
latices9313763_latices
latinas74416463_latinas
latinos73613803_latinos
latkes104715873_lat_kes
latrines8515003_latrines
lattens75014673_lattens
lattes65324203_lat_tes
lauans65113533_lauan_s
lavages1138603_lavages
lawines103313563_lawines
lianes63819323_l_ianes
litanies8310993_litanies
maltases1039693maltases
montanes101114523montanes
octanes91111393_octanes
paeans85118263p_aean_s
pagans95717923p_agan_s
palaces114216453p_alaces
palatals1037773palata_ls
palates93624933p_alates
palatine10316063palatine_
palpates122613063palpates
panes76148693p___anes
pannes85522853p_a_nnes
parades104121463p_arades
parangs104314373p_arangs
parataxes1846393parataxes
paravanes1448303paravanes
partakes1449923partakes
partans94418283partan_s
patacas11311003p_atacas
patches143320383p_atches
patens84820863p_aten_s
patents94815203p_atents
pates76047893p_at__es
patinas96318523p_atinas
patine85328123p_atine_
patined105114783p_atined
patins87528783p_atin_s
patness92912283p_at_ness
patsies93919483p_atsies
pattens95414923p_attens
patties93425143p_atties
pavane114113443p_avane_
pavans115715593p_avan_s
peasants1038263peasants
pectases122411193pectases
pectates122213953pectates
pectines121914683pectines
pentane9415743pentane_
pentenes10315633pentenes
peptones12311033peptones
phalanges1565363phalanges
phalanxes2153913phalanxes
phytane1545443phytane_
pilotages1245503pilotages
pintanos10107553pintanos
pittances1345703pittances
placards1345813placards
placate11312433placate_
placated1338453placated
placater1238013placater
placaters1336473placaters
places104323703pl__aces
plafonds1443273plafonds
plages94520153pl__ages
plagues103311063pla_gues
plaices11411143pla_ices
plained103812233pla_ined
plainer93811983pla_iner
plainest10313613pla_inest
plainness1155183plainness
plains85019593pla_in_s
plaints94012053pla_ints
plaitings12296243plaitings
planate9314573planate_
planches153111863planches
plane74929143pl__ane_
planed94420913pl__aned
planeness1138153planeness
planer84122653pl__aner
planers94517943pl__aners
planet84228353pl__anet
planets93914083pl__anets
planks124116753pl__anks
planned103810153pla_nned
planner93511623pla_nner
planners10399933pla_nners
plans75731273pl__an_s
plantains1147493plantains
plantings12348403plantings
plants84921803pl__ants
plaques18317893pla_ques
plashes124417393pla_shes
plate74635113plat__e_
plateaued1242573plateaued
plateaus1035533plateaus
plated95225773plat__ed
platelet10510733platelet
platelets1165763platelets
platen84518203plat__en
plater84427693plat__er
platers93924093plat_ers
platier93716293plat_ier
platiest103216083plat_iest
platina94413643platin_a
plating103823073platin_g
platinic1237073platinic
platinizes2147793platinizes
platinous1146193platinous
platinum1245443platinum
platinums1343963platinums
platonic1238773platonic
platonism1397543platonism
platooned1244393platooned
platoons1038683platoons
plats75531373plat___s
platted103614263plat_ted
platter93917413plat_ter
platters103415283platters
platypus1542353platypus
platys11459853plat__ys
playacts1543813playacts
playas114612283playa__s
playdates1554903playdates
playlands1543893playlands
playmates1646603playmates
playpens1534073playpens
playtimes1644413playtimes
plazas17409913plaza__s
pleasances1444193pleasances
pleases94515483pl_eases
pleiades1145753pleiades
plotlines1146823plotlines
plottages1244243plottages
plotties103111413plotties
plotzes18317703plot_zes
plumages1335653plumages
plutons938343pluton_s
portages112613223portages
portances1349833portances
postages112815323postages
potages102416423p_otages
pottages112910453pottages
poutines102415103poutines
pralines102217723pralines
prates84633163prat__es
prattles10189403prattles
pretapes122811533pretapes
pristanes11410433pristanes
profanes132311573profanes
propanes122415823propanes
protases102115033protases
ratanies8312923_ratanies
ratans63819373_ratan_s
ratines75328583_ratines
rhatanies1244983rhatanies
saltines82917793saltines
satangs8479713_satangs
slatches131511523slatches
slates64934063slat__es
slatiness92511363slatiness
slatings94011723slatings
soutanes8312933soutanes
stanes64933403__stanes
watapes12228383_watapes

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622327.75018859.6
3Display Results2322320.1102109.1
 (SQL Overall)1786912328.28321573.2
 
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.