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 “testified” 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
testified139784(None) 
testifier12116891testifier
testifies12139261testifies
beatified1577862beatified
certified1548422certified
justified2045042justified
mystified1845082mystified
rectified1539252rectified
retestified1554282retestified
terrified13147582terrified
testifiers13124502testifiers
acetified1545893acetified
aerified121310143ae_rified
basified1437823bas_ified
beatifies1459283beatifies
beautified1654223beautified
bestirred1243813bestirred
brutified1544773brutified
certifier1447353certifier
certifies14310323certifies
citified1438253_citified
deified123112413de__ified
demystified2152183demystified
densified1446713densified
desertified1654103desertified
destined103312453desti_ned
destinies10410843destinies
edified12339713_e_dified
esterified1445403_esterified
fortified1646503fortified
gasified1336533gas_ified
gentrified1545683gentrified
gratified1446253gratified
identified1545053identified
jellified2044813jellified
justifier1944363justifier
justifies1945793justifies
metrified1547863metrified
mortified1547383mortified
mystifier1744363mystifier
mystifies1745883mystifies
notified1238363_notified
ossified1276433_ossified
pesticide1447283pesticide
petrified1548343petrified
prettified1644943prettified
ratified12310503_ratified
rectifier1457733rectifier
rectifies14310813rectifies
reedified1446503reedified
reified112913783re__ified
rejustified2253033rejustified
renotified1455813renotified
resifted12310153res_ifted
resinified1445763resinified
restaffed1653753restaffed
restudied11104853restudied
restuffed1663333restuffed
retestifies1444533retestifies
reunified1346593reunified
russified1344733russified
sissified1345543sissified
stellified1443463stellified
stiffed14359583__stiffed
stifled113511093__stifled
stimied10310623__stimied
stratified1445173stratified
stultified1442943stultified
tackified1944713tackified
tepefied1444573te_pefied
terrifier12126603terrifier
terrifies12139723terrifies
testacies1148373testacies
tested74421523test___ed
testicle1037443testicle_
testicles1146773testicles
testier74015643test__ier
testify13246943testif__y
testifying1745403testifying
torrified13125593torrified
typified1743923t_ypified
verbified18146023verbified
verified151510403ve_rified
versified16147603versified

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.423422437.4
2DLD Change Limit148641846.95321378.0
3Display Results84840.0302800.0
 (SQL Overall)178691847.40624127.9
 
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.