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 “teratism” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
teratism1031217(None) 
teratisms11410071teratisms
erotism9312302_erotism
etatism9610292_etatism
tarantism1146232tarantism
terais64023512tera_is_
treatise8311102treatise
acrotism1248223acrotism
aerates74627493aerates_
aerating92821003aerating
aeration8319933aeration
berates94126873berates_
berating113220763berating
brutism1146773_brutism
ceramist12310933ceramist
cerates95428253cerates_
ceratin93020163cerati_n
ceratins102818733ceratins
defeatism1544413defeatism
derates84028893derates_
derating103222283derating
derats74625063derat_s_
egotism1038353_egotism
elitism939763_elitism
erethism1345863_erethism
ergotism1146273_ergotism
erotisms10310163_erotisms
etatisms1038293_etatisms
etatist7415033_etatist
exotism1638123_exotism
faradism14188373faradism
gelatis83313513gelatis_
geranium1147053geranium
gratis74819243_gratis_
helotism1347703helotism
herbalism1647583herbalism
hermetism1646643hermetism
hermitism1646143hermitism
heroism12311013her_oism
iterates81317823iterates_
iterating10314253iterating
iteration9515033iteration
iterative12410713iterative
keratin113314153kerati_n
keratins122313483keratins
keratose1245503keratose
leftism12226093le_ftism
legalism1148583legalism
literalism1248853literalism
literatim11127183literati_m
melanism1239363melanism
moralism12312363moralism
nepotism1246483nepotism
oralism9513763_oralism
predatism1447283predatism
prelatism1347853prelatism
racism103214193__racism
realism93115923re_alism
rebaptism1552983rebaptism
reraise7316313rera_ise
ruralism1048533ruralism
separatism1455603separatism
serais64326133sera_is_
serialism11811983serialism
seriatim1049223seriati_m
statism9412283_statism
tarantisms1245533tarantisms
tarantist948913tarantist
tartish101512633tar_tish
teatime9310083te_atime
teats55636813te_at_s_
terai53525483tera_i__
teraohm1244783tera_ohm
teraohms1343703teraohms
teraphim1545003teraphim
teratoid9411073teratoid
teratoma1047143teratoma
terbium1147293ter_bium
termtime1244773termtime
terrarium1145353terrarium
territs72714503territs_
terrorism1186433terrorism
tertial7313863ter_tial
tertian7511193ter_tian
testis64916713te_stis_
tetanise8610203tetanise
therapist1447083therapist
tiramisu1045123tiramisu
titanism1048213titanism
totalism10311093totalism
traits65121983t_raits_
treaties8316983treaties
treating92519613treating
treatises9310373treatises
treats64821693treat_s_
triadism1147553triadism
tritium969013t_ritium
tropism1139293t_ropism
truism8118623t_r_uism
tsarism958253t_sarism
tzarism1866323t_zarism
uranism91112513_uranism
veganism1446443veganism
veratrum1344313veratrum
verbalism1647373verbalism
verbatim1545033verbati_m
verism113214263ver__ism

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.420425454.8
2DLD Change Limit1461621077.51619446.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.98222386.7
 
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.