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

42 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
tetrapod114512(None) 
tetrapods1244741tetrapods
tetracid1147262tetracid
tetrad73612052tetra__d
tetragon945272tetragon
tetraploid1354212tetraploid
bedraped1455823bedraped
betrayed1436303betrayed
decapod1335433de_capod
hexapod2043653he_xapod
megapod1344893me_gapod
metrazol1943513metrazol
ostracod1144873ostracod
pteropod1344663pte_ropod
retaped103814283ret_aped
retraced111413023retraced
teapot8416763te__apot
teapoy1138113te__apoy
teraph11319093te_rap_h
teratoid9411073te_ratoid
terraced11318123terraced
terrapin1046203terrapin
tetanoid947203tet_anoid
tetra53417953tetra___
tetrachord1653383tetrachord
tetracids1245933tetracids
tetradic1145813tetradic
tetrads82910193tetra_ds
tetragons1045353tetragons
tetralogy1344163tetralogy
tetramer1046813tetramer
tetraploids1453703tetraploids
tetraploidy1752923tetraploidy
tetrarch13104783tetrarch
tetras63017623tetra__s
tetraspore1253703tetraspore
tetrode839343tetr__ode
tetroxid1646453tetroxid
theropod1445433theropod
titrated92611683titrated
titrator858543titrator
tripod9399853__tripod

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit146162427.33019940.2
3Display Results42420.0162625.0
 (SQL Overall)178691427.75223051.0
 
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.