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

103 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
polentas103874(None) 
polenta9310091polenta_
podestas1146852podestas
polecats1248832polecats
polestar1047112polestar
polestars1157282polestars
polynyas1644452polynyas
boletes9316063bole_tes
boletus948643bole_tus
celestas1057083celestas
centas85020703__centas
cholents1337623cholent_s
docents102810803docent_s
dozenths2142793dozenths
foments122912053foment_s
galenas83310333galen_as
lentos65317403__lentos
lomenta92710133lomenta_
loments93413473loment_s
magentas1137923magentas
melenas999203melen_as
molests93311563molest_s
momenta11299853momenta_
momentos12338333momentos
moments113113123moment_s
mozettas1993543mozettas
muletas937383mule_tas
novenas1036893noven_as
obentos936703_obentos
oleates7417833_oleates
olestras846583_olestras
omenta83411723_omenta_
omental93210413_omental
paleness10312983paleness
palestras1145723palestras
palets85122313pale_t_s
palettes103112833palettes
parental10310943parental
parents93418123parent_s
patents94815203patent_s
pelotas9410723pel_otas
pentad9313763p__entad
pentads1039523p__entads
pesetas938753pese_tas
pietas84516503p_ie_tas
pimentos1246233pimentos
pintas85021393p__intas
piolets93513193piole_t_s
placentas1364823placentas
plantar9369993p_lantar
plants84921803p_lant_s
pleas75627033p_le__as
pleats85218593p_leat_s
plena75816393p_len_a_
plenties10314693p_lenties
plenty11311413p_lent_y
plenums1136533p_lenums
pleuras937413p_leuras
plinths1236123p_linths
podesta1036763podesta_
poets76024443po_e_t_s
pogonias1148513pogonias
pointes93216753po_intes
points85618533po_int_s
poleax1547993pole__ax
poleaxes1767273poleaxes
polecat11313143pole_cat
poleis86018353pole__is
poleless1089873poleless
polemics1448183polemics
polers84225643pole__rs
poles75351003pole___s
poleyns1236113pole_yns
polkas1239103pol__kas
pollenate1157143pollenate
pollenates1246743pollenates
pollens93713303pollen__s
pollutes1037613pollutes
polyanthas18183173polyanthas
polyenes13510063polyen_es
polynya1544063polynya_
polyomas1546993polyomas
polypneas1644003polypneas
ponent82821593ponent__
pontes83627853po__ntes
portents103512823portent_s
potences12710693potences
potent84223353potent__
potentate1197253potentate
potentates12106323potentates
potential1148523potential
potentials1245533potentials
potently1347403potently
relents74018503relent_s
rodents8611543rodent_s
silents73514493silent_s
sklents11348163sklent_s
soleness8814263soleness
solvents1136763solvent_s
splents93912133splent_s
talents7312013talent_s
tomenta9319833tomenta_
yentas94614213__yentas

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.1701051123.5
2DLD Change Limit1461621037.70618967.3
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.92222556.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.