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

129 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
parlante103969(None) 
parlance1248721parlance
palate84226792pa_la_te
parlances1348962parlances
parlando1145412parlando
ablate82219213_abla_te
alane56135613_a_lan_e
alant55742293_a_lant_
alants67722023_a_lants
alate55340333_a_la_te
allanite8411093_allanite
andante8311273_andante
arcane81216743_arcan_e
arrange838683_arrange
arrant6623253_arrant_
aslant6317753_aslant_
atlantes838553_atlantes
balance11510263ba_lance
barbate11314543barba_te
callant94121223callant_
callants104112143callants
carate84734003car_a_te
carcanet12316353carcanet
carinate103320253carinate
carline93923623carlin_e
gallant83517113gallant_
gallanted1145903gallanted
gallants93310373gallants
gallate83417133galla_te
gardant9314463gardant_
garland948703garlan_d
garlanded1244693garlanded
garlands1038323garlands
karate105320923kar_a_te
malate84624563ma_la_te
maranta9311693mar_anta
marinate103017783marinate
marline93320973marlin_e
marlite92917083marl_ite
narrate7313493narra_te
pageant10312783pageant_
pageants1136693pageants
paginate114012443paginate
palace104516923pa_la_ce
palates93624943pa_la_tes
paleate94120003pa_leate
palette93613983pa_lette
pallette1039513pallette
palliate10311893palliate
palmate113215233pa_lmate
palpate113213923pa_lpate
parable111819783par_able
parade94720643par_a_de
parae76335703par_a__e
parakite14410423parakite
paralyse1347483paralyse
paralyze2246633paralyze
parang93715513par_an_g
parangs104314383par_angs
paranoea1048583par_anoea
parapet11317643par_apet
parasite10314843parasite
paravane1348103paravan_e
parbake1538353parba_ke
pardine103616733pardin_e
parent83230423par_ent_
parented11912213par_ented
parents93418133par_ents
parfait12312053parfait_
parfaits1346913parfaits
parian83223963parian__
parians93519743parian_s
parkade1437583parka_de
parkette14138023parkette
parkland1545373parklan_d
parklands1654723parklands
parlay113713993parla__y
parlayed1435823parlayed
parlays123910453parla_ys
parle75836163parl___e
parling103823763parlin_g
parolable1347113parolable
parsable12311693parsable
partake1339643parta_ke
partan83820563partan__
partans94418283partan_s
partite9317133par_tite
parvenue1344933parvenue
passant9813943passant_
patinate103016313patinate
patriate10311933patria_te
pavane114113443pa_van_e
pearlite1039443pearl_ite
perianth1348553perianth
perlite9317323perl_ite
phalange1465193phalange
picante11310523p_icante
pirate82322883pir_a_te
planate9314573p__lanate
plane74929143p__lan_e
planet84228353p__lanet
plant75437113p__lant_
planted103516123p__lanted
planter94017803p__lanter
plants84921803p__lants
plate74635113p__la_te
portance12310123portance
praline93019743pralin_e
prance104318573p_r_ance
prate75135983p_r_a_te
prelate9519693prela_te
prolate9419793prola_te
pronate9418873p_ronate
purline93516533purlin_e
purslane1045783purslan_e
valance1269253va_lance
vallate103016563valla_te
variance1397413variance
variant10316803variant_
variants1139203variants
variate101316433varia_te
volante1038513_volante
warplane1345983warplan_e
warrant10614243warrant_
warranted1345013warranted
warrantee1245283warrantee
warranter1245203warranter
warrants1168503warrants
warranty1465043warranty

Search took 8 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.406440125.6
2DLD Change Limit1461621297.37319824.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.82522835.9
 
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.