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

88 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
pompano134520(None) 
pompanos1445241pompanos
company1619711142company
poblano1145092poblano
pompon1238942pompon_
pompons1338552pompons
romano84912942rom_ano
timpano11235862timpano
tympano14245282tympano
command14399213command
commando15275753commando
compact153712213compact
companion1577683companion
compare135814993compare
compart134016003compart
compas125817063compa_s
compass13379563compass
compend144010303compend
comping143518593comping
compo115318573comp__o
compone136517193compone
compony1613011913compony
domino92611493dom_ino
dopant9316133do_pant
mano66536813__m_ano
oompah1334253oompa_h
oompahs1434263oompahs
paesano9338793paesano
paisano9429513paisano
pampa114913423pampa__
pampas124913993pampa_s
pampean1335543pampean_
pampeans1444703pampeans
pampero13328093pampero
pepino10310333p_epino
piano76118713p__iano
pimping143812123pimping
pintano998993pintano
poblanos1244993poblanos
pomace123111913pom_ace
pomade113611333pom_ade
pomelo10238663pom_elo
pomo85828453pom___o
pomp106225463pomp___
pompadour1692073pompadour
pompom1436493pomp_om
pompoms1535333pompoms
pompous1338063pompous
pomps115316193pomp__s
pooping123615443pooping
poppa8409893poppa__
poppadom1462573poppadom
poppas93710713poppa_s
popping113715413popping
porcino1138113porcino
porno75120653po__rno
potato8513433po_tato
potman102813573potman_
propane112716153propane
propman1339063propman_
pumping144213553pumping
rampant11312173rampant
roman75424823rom_an_
romanos94311483rom_anos
romans84620243rom_ans
romping123113033romping
sampan102511893sampan_
sampans112411003sampans
solano65314183so_lano
soman75024903som_an_
somans84619303som_ans
soprano937003soprano
tampan102512323tampan_
tampans113310983tampans
timpana11226133timpana
timpani11266153timpani
toman75724053tom_an_
tomans85419133tom_ans
tomato8313453tom_ato
tompion11247103tompion
tympan13257013tympan_
tympana14255853tympana
tympani14275923tympani
tympans14236813tympans
tympany17254603tympany
volcano1244613volcano
woman105818003wom_an_
womans114613653wom_ans

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 Filter1786911340270.420425454.8
2DLD Change Limit134027886.86019537.5
3Display Results88880.0302933.3
 (SQL Overall)178691887.31024444.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.