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

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

71 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
econometrists176272(None) 
econometrist1664101econometrist_
econometrics1854152econometri_cs
econometric1755363econometri__c
economists1446953econom___ists
concretists1555464_concret_ists
consumerists1672664_consume_rists
econometrician20102504econometrician
econometricians21122114econometricians
economises1446564econom___ises
economist1348884econom___ist_
ecotourists1352644ecoto__urists
optometrists1652404_optometrists
tonometries1347214_tonometri_es
actinometries1754105actinometri_es
aeronomists1355635aeronom___ists
axonometric2264485axonometri__c
bionomists1444905bionom___ists
canoeists1147165_cano_e__ists
centrists11410235_cen___trists
chronometries2054115chronometri_es
cliometrics1754785_cliometri_cs
coleopterists1762385_coleopterists
colorists112313595_colo___rists
computerists18193915_computerists
concretisms1764435_concret_isms
concretist1448195_concret_ist_
constricts1477735_con__stricts
consumerisms1872495_consume_risms
consumerist1574265_consume_rist_
contrasts112211045_con___trasts
cornetists1245955_co_rnet_ists
cornettists1353095_co_rnettists
coulometries1654655_coulometri_es
ecofeminists1972175ecofem_inists
ecologists13310925ecolo___gists
econometrically24133345econometrically
economics1545905econom___i_cs
economies1348625econom___i_es
economise1346055econom___is_e
economised1544205econom___ised
economizes2345375econom___izes
ecoterrorists1561305ecoterrorists
ecotourisms1552255ecoto__urisms
ecotourist1253735ecoto__urist_
ecumenists14144205ec__ume_nists
enamelists1244565e__name_lists
endometrioses16131935e_ndometrioses
endometriosis16171735e_ndometriosis
endometritis1562915e_ndometritis
ergometries1455685e_rgometri_es
ergonomists1473515ergonom___ists
ethnocentrisms2171425ethnocentrisms
euhemerists1652225e_uheme_rists
exodontists1952225exodo_nt_ists
exonumists1953155exonum___ists
geometrises14165665__geometrises
goniometries1554645_goniometri_es
iconolatries1452575iconolatri_es
iodometries1455935_iodometri_es
manometries1547255_manometri_es
metrists1039855_____metrists
monetarists1355615_mon__etarists
monometallists1872375_monometallists
nonmonetarists1662035_nonmonetarists
odometries1346825__odometri_es
optometrist1554435_optometrist_
phonetists1545415phon__et_ists
photometries1968335photometri_es
sociometries1654995sociometri_es
zoometries2147075_zo_ometri_es

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790719.11013698.1
3Display Results71710.0461543.5
 (SQL Overall)178691719.31219189.3
 
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.