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

117 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
planishes1413852(None) 
planished1566121planished
planisher1495851planisher
planishers1584771planishers
plenishes1487081plenishes
banishes131812462_banishes
blandishes1644612blandishes
danishes121710492_danishes
evanishes1545602evanishes
lavishes1457402_lavishes
panfishes1737592p_anfishes
parishes13314752p_arishes
planches153111862plan_ches
planish12412052planish__
plashes124417392pla__shes
plenished1584952plenished
punishes1338112p_unishes
vanishes141610752_vanishes
alanines8314803alani_nes
anises64826693__anis_es
banished14189063_banished
banisher13169183_banisher
banishers14258053_banishers
blanches153311603blan_ches
blandished1743333blandished
blandisher1643463blandisher
blandishers1743003blandishers
blemishes1665083blemishes
brandishes1645893brandishes
burnishes1436643burnishes
clashes124017283cla__shes
evanished1644323evanished
famishes1658283_famishes
finishes1438983_finishes
flashes133916103fla__shes
flatfishes1943993flatfishes
flemishes1765243flemishes
furnishes1536233furnishes
garnishes13198813garnishes
glacises1138503glacis_es
knishes1438263__knishes
kyanises15206393kyanis_es
languishes1444243_languishes
lapises93513463_lapis_es
lashes94831003_la__shes
lavashes1445573_lavashes
lavished1555133_lavished
lavisher1445083_lavisher
lavishers1564643_lavishers
lavishest1554883_lavishest
marishes13512553_marishes
minishes13310583_minishes
monishes13311483_monishes
paganises1239723paganis_es
painches1588913p_ainches
panaches15310283p_anaches
panicles121010113p_anicles
panoches1548123p_anoches
pansies94521983p_an_sies
parises94827183p_aris_es
pashes115828393p_a__shes
pavises125315493p_avis_es
pavisses13397103p_avisses
penises9318193p_enis_es
perishes13313753p_erishes
pharisees1444633pharisees
pianisms1249013pianis_ms
pianists1049013pianis_ts
pigfishes1845003pigfishes
pinfishes1746243pinfishes
pishes114722103p___ishes
plaices11411143pla_i_ces
plainsmen1343463plainsmen
plaister1068013pla_ister
plaisters1137813pla_isters
planche14299753plan_che_
planchet152511963plan_chet
planchets16236743plan_chets
planes85028083plan___es
planesides1354373planesides
planishing1645323planishing
planisphere1852243planisphere
planispheres1952063planispheres
planosols1143943planosols
plantsmen1344143plantsmen
plashed133712643pla__shed
plasher124215033pla__sher
plashers133813453pla__shers
platies93722543plati__es
platyfishes2252193platyfishes
plenches153110623plen_ches
plenish1239943plenish__
plenisms1237963plenis_ms
plenists1038253plenis_ts
plisses94411773pl__isses
plushes124313673pl__ushes
polarises11514073polaris_es
polishes13711783p_olishes
praises94121103pra_is_es
praxises1739063praxis_es
publishes1645933publishes
punished1436043p_unished
punisher1335773p_unisher
punishers1434973p_unishers
pupfishes1944313pupfishes
radishes1269463_radishes
ravishes1478043_ravishes
replenishes1653053replenishes
slashes103619103sla__shes
splashes1337503spla__shes
standishes1445713standishes
stonishes1247363stonishes
tarnishes12188893tarnishes
vanished15207743_vanished
vanisher14167453_vanisher
vanishers15186613_vanishers
varnishes15207913varnishes

Search took 7 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 Filter1786911486410.440406115.9
2DLD Change Limit1486411176.23323847.4
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.71926594.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.