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

63 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
tortrix144419(None) 
oratrix1444532_oratrix
tectrix1644262tectrix
torrid7311852tor_rid
tortrixes1644152tortrixes
aortic8316613aort_ic
corrie83621223cor_rie
cortex15311473cort_ex
cortin82423153cort_in
editrix1543643editrix
fornix1636033for_nix
forrit91916623for_rit
fortis95418613fort_is
heretrix1845133heretrix
heritrix1843893heritrix
horrid10311563hor_rid
matrix1539843_matrix
morris83814733mor_ris
nostril749303nostril
orris54516553_or_ris
outrig72812853_outrig
portrait10510323portrait
portray1237483portray
postfix1944683postfix
rectrix1645363rectrix
sortie63621993sort_ie
tantric939583tantric
tartaric1047053tartaric
territ63421373ter_rit
tetri52716453t_etri_
tetris62816293t_etris
tomtit8413853tomt_it
tootsie737133tootsie
torero6313203torer_o
toreros7311343toreros
tori47542153to__ri_
toric76529313to__ric
torii55521593to__rii
toroid7416013tor_oid
torpid9310913tor_pid
torr45630903tor_r__
torrify1335013tor_rify
torrs53923563tor_r_s
torsi57423363tor_si_
tort46967463tort___
torta55925353tort__a
tortas64918253tort_as
torte55431703tort__e
torten65314353tort_en
tortes64826053tort_es
tortile7313193tortile
tortoise847093tortoise
tortoni738033tortoni
tortonis848743tortonis
tortricid1252913tortricid
torts56138123tort__s
torture738593torture
tortured935843tortured
torturer835493torturer
tortures838913tortures
torturing1036253torturing
vortex1635923vort_ex
worrit92313313wor_rit

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.420425454.8
2DLD Change Limit134027636.40620922.1
3Display Results63630.0302100.0
 (SQL Overall)178691636.85626063.4
 
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.