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

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

42 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
interferometric2210177(None) 
interferometry2261812interferometr_y
interferometer19132193interferomet_er
interferometers20141903interferometers
anthropometric2373005anthr_opometric
interferer1347735interfer__e_r__
interferers1446185interfer__e_r_s
interferogram1972225interfero__gram
intergeneric1563915interge__ne_ric
nephelometric2262455_n_ephelometric
amperometric2063476___amperometric
astrometric1555996ast____rometric
biotelemetric1961896biote_le__metric
diastereomeric197716diaster_e_ome_ric
ergometric1545996___er__gometric
interatomic1553846inter_atom___ic
interepidemic2061246inter_epide_mic
interfere12410816interfer__e____
interfered1448536interfer__e___d
interference1756016interfer__e_nce
interferences1855476interfer__ences
interferential1763976interfer_ential
interferes1349986interfer__e___s
interferograms2071566interfero_grams
interferon1346856interfero_____n
interferons1446746interfero____ns
interfertile1556426interfer___tile
intermitotic1653116intermito__t_ic
interoceanic1653876int___eroceanic
interpermeate1754236interper_me_ate
interpermeated1963216interper_meated
interpermeates1863466interper_meates
interpermeating2063076interper_meating
intervalometer1981436intervalomet_er
intervalometers20101176intervalometers
intervertebral1961656interver_tebral
potentiometric2071266pote_ntiometric
respirometric1961916__respirometric
spectrometric21103066_spe_ctrometric
telemetric1455086__te_le__metric
tensiometric1653996__te_nsiometric
thermometric2154456_ther__mometric

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 Filter178691950240.360496363.9
2DLD Change Limit95024427.84312115.8
3Display Results42420.0301400.0
 (SQL Overall)178691428.23321704.2
 
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.