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

87 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
tetrad73612051tetrad_
tetrads82910191tetrads
detract101414632detract
retract91318112retract
tetra53417952tetra__
tetradic1145812tetradic
tetras63017622tetra_s
tetrode839342tetrode
titrant7315192titrant
attract9511833attract
betray111511443betra_y
betrays12127823betrays
bewrapt14147133bewrapt
degrade10229903degrade
derat65044083de_ra_t
detracts11138833detracts
detrain8412253detrain
detrude936083detrude
enrapt8313013_enrapt
entrant7318873entrant
errant6618733_errant
extract16311013extract
intrant7318753intrant
iterant7317783ite_rant
metred95315143metred_
metrist9317063metrist
petard95013803petard_
petards104311153petards
petrale9312623petrale
redraft11310573redraft
refract121311603refract
regrade92612033regrade
regraft11310153regraft
regrant8317323regrant
retard75018933retard_
retards85015003retards
retirant8313593retirant
retrace91417343retrace
retrack131310723retrack
retracts101111313retracts
retrain7615423retrain
retral64419743retra_l
retread849003retread_
retreads937823retreads
retreat7317533retreat
retroact10410003retroact
rewrapt12138113rewrapt
strait64025893_strait
teacart91113193teacart
teared75722153teared_
teat45963633te__a_t
tenant6322473te_nant
terai53525483te_ra_i
terais64023513te_rais
teraph11319093te_raph
tercet83624913te_rcet
teredo7310783te_redo
terra54419663terra__
terrace93311843terrace
terrae62915213terra_e
terrain7410853terrain
terrane72814233terrane
terras63516973terra_s
terret63425623te_rret
territ63421373te_rrit
tetany959843tet_any
tetracid1147263tetracid
tetracids1245933tetracids
tetragon945273tetragon
tetramer1046813tetramer
tetrapod1145123tetrapod
tetrapods1244743tetrapods
tetrarch13104783tetrarch
tetri52716453tetr__i
tetris62816293tetr_is
tetrodes939093tetrodes
tetryl935693tetr_yl
tetryls1034643tetryls
tirade7311693t_irade
titrants838483titrants
titrate72215573titrate
tract75635713__tract
trad55630913__trad_
trade65026043__trade
trait56940843__trait
trapt76433393__trapt
tyrant9315333t_yrant

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.406440125.6
2DLD Change Limit134027876.18621666.2
3Display Results87870.0332636.4
 (SQL Overall)178691876.62526972.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.