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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
piezometers244383(None) 
piezometer2343751piezometer_
pedometers1547212p_edometers
picometers1648282pi_cometers
aerometers1249483_aerometers
anemometers1544653anemometers
biometers1339173bi__ometers
ceilometers1545513ceilometers
geometers1238193_ge_ometers
kilometers1686653ki_lometers
micrometers1749073micrometers
pedometer1447733p_edometer_
perimeters1448593p_erimeters
photometers1848443photometers
picometer1548913pi_cometer_
picometres1647223pi_cometres
piezometric2654013piezometric
potometers1449063p_otometers
pycnometers2044453pycnometers
pyrometers1748333p_yrometers
rheometers1545753rhe_ometers
speedometers1752773speedometers
spherometers1954003spherometers
spirometers1545803spi_rometers
viscometers1854943viscometers
aerometer11410204_aerometer_
algometers1346004_algometers
anemometer1444844anemometer_
atmometers1445874_atmometers
audiometers1444504audiometers
barometers14198514_barometers
biometer1239604bi__ometer_
bolometers1447384_bolometers
ceilometer1445434ceilometer_
clinometers1544724clinometers
coulometers1545104coulometers
cryometers1746004_cryometers
cyclometers2045184cyclometers
decameters15156594_decameters
decimeters15156684_decimeters
dekameters17164864_dekameters
diameters1247594di__ameters
dilatometers1553114dilatometers
dimeters11411094di___meters
durometers1356374_durometers
ergometers1345784_ergometers
eudiometers1444144eudiometers
gasometers1346644_gasometers
geometer1138424_ge_ometer_
goniometers1444854goniometers
hectometers1846064hectometers
heliometers1646024heliometers
hexameters2244454_hexameters
hydrometers2095944hydrometers
hygrometers2084454hygrometers
hypsometers2153774hypsometers
kilometer1576934ki_lometer_
kilometres16115784ki_lometres
manometers1448024_manometers
micrometer16410144micrometer_
millimeters1544154millimeters
monometers1449364_monometers
nanometers1247124_nanometers
nephelometers2072414nephelometers
odometers1247134__odometers
optometers1456744_optometers
orometers11310424__orometers
osmometers1444924_osmometers
parameters1448124p_arameters
penetrometers1752774penetrometers
pentameters1544494pentameters
perimeter1349554p_erimeter_
photometer1749224photometer_
picketers17196484pi__cketers
picometre1546554pi_comet_re
pioneers1035864pi__one_ers
pistoleers1243794pistole_ers
planimeters1543464planimeters
potometer1349844p_otometer_
promoters13310094p__romoters
prompters1537554p__rompters
pycnometer1944374pycnometer_
pyrometer1648884p_yrometer_
radiometers1466174radiometers
rheometer1446094rhe_ometer_
salometers1258074_salometers
sclerometers1654034sclerometers
seismometers1663004seismometers
speedometer1653064speedometer_
spherometer1854154spherometer_
spirometer1445764spi_rometer_
tachometers1855074tachometers
telemeters1246684_telemeters
thermometers1964914thermometers
tiltmeters1244124ti_ltmeters
tonometers1248114_tonometers
udometers1245744__udometers
urinometers1344694urinometers
variometers1645164variometers
viscometer1745304viscometer_
zymometers261986934_zymometers

Search took 10 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 Filter1786911488190.1561145455.1
2DLD Change Limit1488191019.09316366.3
3Display Results1011010.0462195.7
 (SQL Overall)1786911019.29519224.4
 
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.