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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
porticoes134825(None) 
porticoed1445421porticoed
porticos1238371portico_s
cortices12615012cortic_es
corticose1346042corticose
mortices12711562mortic_es
particles1339802particles
politicoes14265012politicoes
portico11310142portico__
portieres1138212portieres
portions10514412porti_ons
postiches1648222postiches
potiches1539202po_tiches
vortices1369122vortic_es
vorticose1444192vorticose
articles10310243_articles
cornices12713293cornic_es
corniches1666673corniches
cornicles1368243cornicles
corticoid1445453corticoid
corticoids1544183corticoids
cortisols1144783cortisols
cortisones1267053cortisones
fornices1369103fornic_es
forties104323863forti__es
fortifies1548693fortifies
mortice11711493mortic_e_
morticed1377163mortic_ed
mortifies1439393mortifies
mortises10713613morti_ses
notices9312283no_tic_es
orrices9129363_orric_es
orthicons1443423_orthicons
particle1239533particle_
parties93230863parti__es
pastiches1637453pastiches
pericopes1547873per_icopes
pettitoes1144183pettitoes
poeticizes2347133poeticizes
poetics11312073poetic__s
poetises10313953poeti_ses
poetizes19310253poeti_zes
polices113118053po_lic_es
policies122415663po_licies
politicos13287083politico_s
pollices12410753pollic_es
popsicles1543663popsicles
porches143815673por__ches
porgies103017003porgi__es
porkies133416493porki__es
porridges1343913porridges
portables1337873portables
portages112613223port_ages
portances1349833portances
portholes14410373portholes
portiere1038773portiere_
portion9615493porti_o_n
portioned1248333portioned
portioner1158683portioner
portioners1257413portioners
postcodes1446153post_codes
postiche1547793postiche_
posties93128813posti__es
postiques2045833postiques
potatoes1039943po_tatoes
potiche1438043po_tiche_
potions93417423po_ti_ons
potties93723543potti__es
poultices1345673poultic_es
poutines102415103pouti_nes
prices104524543p_r_ic_es
protocols1347203protocols
provisoes1446653provisoes
sorties74126403sorti__es
tortious839023torti_ous
vertices13612283vertic_es
vertigoes1354703vertigoes

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 Filter1786911486410.436409841.7
2DLD Change Limit148641777.73319221.6
3Display Results77770.0332333.3
 (SQL Overall)178691778.20221786.3
 
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.