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

38 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
terrorize188708(None) 
terrorise997171terrorise
terrorized2075701terrorized
terrorizes1987061terrorizes
temporize2246872temporize
terrorised1184842terrorised
terrorises1087432terrorises
terrorism1186432terrorism
terrorist988562terrorist
arborize1988963_arborize
deodorize2045273deodorize
erotize16311663_e_rotize
exteriorize2753863exteriorize
heroize193210973he_ro_ize
interiorize2056343interiorize
memorize211311103me_morize
mercerize2246173mercerize
necrotize2046483necrotize
sermonize20148483sermonize
tellurize1844633tellurize
temporise1347403temporise
temporized2446063temporized
temporizer2345233temporizer
temporizes2346933temporizes
tenderize1976183tenderize
tenorite8311993te_norite
terraria847023terrari_a
terrarium1145353terrarium
terrine72517573te_r_rine
terror63811733terror___
terrorisms12125833terrorisms
terrorists1085613terrorists
terrorizing2145953terrorizing
terrors73112213terror__s
tetroxide1744293tetroxide
teutonize1845893teutonize
texturize2544283texturize
theorize2047073t_heorize

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 Filter1786911486410.440406115.9
2DLD Change Limit148641387.48319863.8
3Display Results38380.0162375.0
 (SQL Overall)178691387.93922508.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.