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

106 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
hygrometers208445(None) 
hydrometers2095941hydrometers
hygrometer1994621hygrometer_
hydrometeors2162712hydrometeors
hydrometer1966682hydrometer_
hypsometers2153772hypsometers
pyrometers1748332py_rometers
aerometers1249483_aerometers
algometers1346003alg_ometers
barometers14198513_barometers
cyclometers2045183cyclometers
durometers1356373_durometers
ergometers1345783erg_ometers
geometers1238193__geometers
hectometers1846063hectometers
heliometers1646023heliometers
hydrometeor2092873hydrometeor
hygrometric2254703hygrometric
hypermeters2155583hypermeters
hypsometer2054063hypsometer_
micrometers1749073micrometers
orometers11310423__orometers
pycnometers2044453pycnometers
pyrometer1648883py_rometer_
spirometers1545803spirometers
zymometers261986933zy_mometers
aerometer11410204_aerometer_
algometer1246534alg_ometer_
anemometers1544654anemometers
atmometers1445874_atmometers
audiometers1444504audiometers
barometer13189044_barometer_
biometers1339174__biometers
bolometers1447384_bolometers
ceilometers1545514ceilometers
chronometers1954034chronometers
clinometers1544724clinometers
copromoters1753984copromoters
coulometers1545104coulometers
cryometers1746004_cryometers
cyclometer1945414cyclometer_
durometer1246444_durometer_
dynameters1643794dy_nameters
dynamometers2062504dynamometers
ergometer1246154erg_ometer_
eudiometers1444144eudiometers
fluorometers17113024fluorometers
gasometers1346644_gasometers
geometer1138424__geometer_
goniometers1444854goniometers
greeters92610114__gr_eeters
grouters95910084__gro_uters
grovelers13305164__grovelers
hectometer1746414hectometer_
heliometer1546304heliometer_
heptameters1853274heptameters
hexameters2244454h_exameters
hydroceles1954604hydrocele_s
hydrolytes2046074hydrolyte_s
hydromels1844794hydrom__els
hydrometric2275894hydrometric
hydropowers2352804hydropowers
hydroseres1745054hydrosere_s
hygrophytes2654114hygrophyte_s
hygrostats1752964hygro_stats
hypermeter2055554hypermeter_
hypocenters2153084hy_pocenters
kilometers1686654_kilometers
lysimeters1543434ly_simeters
manometers1448024_manometers
micrometer16410144micrometer_
monometers1449364_monometers
nanometers1247124_nanometers
odometers1247134__odometers
optometers1456744_optometers
orometer10310704__orometer_
osmometers1444924_osmometers
parameters1448124_parameters
pedometers1547214_pedometers
perimeters1448594_perimeters
photometers1848444photometers
picometers1648284_picometers
piezometers2443834piezometers
potometers1449064_potometers
promoters13310094__promoters
prompters1537554__prompters
psychrometers2563234psychrometers
pycnometer1944374pycnometer_
pyrometry1945624py_romet_ry
radiometers1466174radiometers
rheometers1545754_rheometers
salometers1258074_salometers
sclerometers1654034sclerometers
spherometers1954004spherometers
spirometer1445764spirometer_
tachometers1855074tachometers
tetrameters1354624tetrameters
thermometers1964914thermometers
tonometers1248114_tonometers
trimeters1139214__trimeters
udometers1245744__udometers
urinometers1344694urinometers
variometers1645164variometers
viscometers1854944viscometers
yawmeters1783874_y_awmeters
zymometer25847354zy_mometer_

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 Filter1786911488190.1561145455.1
2DLD Change Limit1488191068.03018532.9
3Display Results1061060.0631682.5
 (SQL Overall)1786911068.24921662.1
 
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.