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

84 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
torrefy135335(None) 
torrify1335011torrify
horrify1635022horrify
orrery936782_orrery
terrify1336352terrify
torrent7313412torrent
cornify1536253cornify
correct11513983correct
corrody13136143corrody
ferrety13287013ferrety
foreby1438633fo_reby
forgery14419303forgery
fortify1636523fortify
horrent10313553horrent
horsefly1744873horsefly
horsey125115403horse_y
lorry86315673lorr__y
mortify1536223mortify
murrey114312253murre_y
ornery938463_ornery
porrect1159743porrect
putrefy1543313putrefy
rarefy12296343_rarefy
reefy114217703__reefy
sorcery1237023sorcery
sorely94618003so_rely
sorrel6413543sorre_l
sorrels7310713sorrels
sorrily1039823sorrily
sorry84618253sorr__y
storey95217613sto_re_y
surrey94414573surre_y
tarre55825633tarre__
tarred74720283tarre_d
tarres64723043tarre_s
tarry85422513tarr__y
tepefy1434803t_epefy
terreen7257573terreen
terrene72411033terrene
terret63425623terre_t
terrets72913573terrets
terry84721873terr__y
tersely1038103tersely
thereby1534633thereby
toffy145310283to__ffy
toggery12505923toggery
toney86027413to_ne_y
torchy14549533to_rchy
tore47359323to_re__
torero6313203to_rero
toreros7311343toreros
tores55352673to_re_s
tories65435883torie_s
torment9316173torment
torpedo1035053torpedo
torr45630903torr___
torrefied13143053torrefied
torrefies12114753torrefies
torrefying1742853torrefying
torrents838143torrents
torrid7311853torr_id
torridly1284463torridly
torrs53923563torr__s
torse55833333torse__
torses64727953torse_s
torte55431703torte__
torten65314353torte_n
tortes64826053torte_s
tory75840543to_r__y
tottery10388483tottery
toured74216153toure_d
tourer64115073toure_r
tourers73512733tourers
tourney1036273tourney
towery124012093to_wery
tref77030993t__ref_
trey77228793t__re_y
tumefy1434223t_umefy
turfy114315403t_ur_fy
turkey1337763turke_y
turnery10357423turnery
turret63121853turre_t
turrets73010673turrets
worry116114333worr__y

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027846.28021341.9
3Display Results84840.0302800.0
 (SQL Overall)178691846.46627635.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.