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

50 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
hyperromantic2510328(None) 
hyperromantics26122611hyperromantics
superromantic1982942superromantic
hypermanic22116633hype_r_man_ic
preromantic1755123__preromantic
hypermania20117174hype_r_man_ia
hyperostotic2254484hype_rostotic
hyperplastic2464974hype_rplastic
hypersonic2087144hyperso__n_ic
hyperstatic2156034hype_rsta_tic
hypertonic2087954hyperto__n_ic
hypomanic2146554hyp___oman_ic
necromantic1754824__necromantic
antiromantic1655495_antiromantic
ferromagnetic2173015__ferromagnetic
geomantic1445985__ge__omantic
hierophantic2262875h_ierophantic
hydromagnetic2562655hy__dromagnetic
hyperbaric2255195hype_r_ba_ric
hyperbolic2255765hyperbo___lic
hypercapnic25113905hype_r_capnic
hypercritic2365775hype_r_critic
hyperemic2146895hype_rem___ic
hyperesthetic2683605hyperesthetic
hypereutectic2562815hypereutectic
hypergolic2155625hypergo___lic
hyperkeratotic2871525hyperkeratotic
hyperkinetic2664225hype_rkinetic
hypermanias21116625hype_r_manias
hypermetric2355545hype_r_metric
hypermnesic2394565hype_r_mnesic
hyperopic2147415hype_ro___pic
hyperparasitic2672665hyperparasitic
hyperphagic2784045hype_rpha_gic
hyperpneic2255175hype_r__pneic
hyperreactive2663315hyperr_eactive
hyperreactor2262575hyperr_eactor
hyperrealistic2462725hyperrealistic
hypersthenic2564385hypersthen_ic
hypertonia18108065hyperto__n_ia
hypertrophic2763685hypertro__phic
hypomania1946725hyp___oman_ia
hypomanics2255075hyp___oman_ics
hypotactic2275455hyp___otactic
postromantic1863225_postromantic
romantic1249245_____romantic
spermatic1548715_spe_r_ma_tic
superorganic1762655superorgan_ic
ultraromantic1772325ultraromantic
unromantic1454705___unromantic

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 Filter1786911247900.406440125.6
2DLD Change Limit124790508.25015126.1
3Display Results50500.0331515.2
 (SQL Overall)178691508.68920565.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.