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

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

41 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
hydrometeor209287(None) 
hydrometeors2162711hydrometeors
hydrometer1966681hydromete_r
hydrometers2095942hydrometers
hygrometer1994622hygromete_r
hydrometric2275893hydrometric
hygrometers2084453hygrometers
hypsometer2054063hypsomete_r
pyrometer1648883py_romete_r
aerometer11410204_aeromete_r
audiometer1344824audiomete_r
barometer13189044_baromete_r
cyclometer1945414cyclomete_r
durometer1246444_duromete_r
eudiometer1344164eudiomete_r
hectometer1746414hectomete_r
heliometer1546304heliomete_r
hydrator1545764hydr__at_or
hydrocele1854574hydrocele__
hydroceles1954604hydrocele_s
hydrolyte1945734hydrolyte__
hydrolytes2046084hydrolyte_s
hydromedusa21151684hydromedusa
hydromel1795354hydrom__e_l
hydromels1844794hydrom__els
hydropower2253434hydropowe_r
hydrosere1644824hydrosere__
hydroseres1745054hydrosere_s
hygrometric2254704hygrometric
hypermeter2055554hypermete_r
hypsometers2153774hypsometers
micrometer16410144micromete_r
odometer1147414_od_omete_r
orometer10310704__oromete_r
pedometer1447734ped_omete_r
pycnometer1944374pycnomete_r
pyrometers1748334py_rometers
radiometer1366434radiomete_r
spirometer1445764spiromete_r
udometer1146334_ud_omete_r
zymometer25847354zy_momete_r

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.420425454.8
2DLD Change Limit148819417.83019006.3
3Display Results41410.0301366.7
 (SQL Overall)178691418.28021581.0
 
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.