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

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

45 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
hryvna154157(None) 
hryvnas1641491hryvnas
hryvnia1641641hryvnia
hryvnias1741622hryvnias
hyena11810252h_yena
arcana8912583arcana
arena55323813ar_ena
brava106414793brav_a
bryony1435833bryony
crying123612283crying
drying113411603drying
fraena938063fraena
frena85915273fr_ena
frying134511403frying
frypan1434543frypan
grana65722093gr_ana
halva115414433halv_a
hariana10310243hariana
haying134420613haying
henna84414043h_enna
hoya107418373hoy__a
hyaena1235363hyaena
hydra12249223h_ydra
hyenas1288953h_yenas
hying126514743h_ying
hyla106716513h_y_la
hymn12311313h_ymn_
hymnal1434913h_ymnal
hymns1337523h_ymns
hypha1637383h_ypha
krona93611793kr_ona
myna95815303_my_na
organa789213organa
prajna1535073prajna
prying124114803prying
regna64614813_regna
rhyta1135083rhy_ta
ruana5312423_ruana
rya67622013_ry__a
rynd86414103_ry_nd
trivia938503trivia
trona54118953tr_ona
trying104214073trying
tryma1037223try_ma
wrying13379623wrying

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit112716454.94022817.0
3Display Results45450.0133461.5
 (SQL Overall)178691455.31333632.8
 
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.