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

103 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
tangrams113616(None) 
pangrams1337151pangrams
tangram1038071tangram_
anagrams1146592_anagrams
engrams1038072_engrams
mantrams12288962mantrams
nanograms1244842nanograms
pangram1239022pangram_
tagrags936122ta_grags
tantras73112092tantra_s
tantrums1045112tantrums
trangams1147202trang_ams
trigrams11116352trigrams
anagram1058193_anagram_
angas65827983_ang_a_s
angoras8811363_angora_s
anoraks1137603_anoraks
antrums969173_antrums
anurans73810553_anurans
ashrams1236653_ashrams
bantams1149063ban_tams
barograms1445863barograms
bhangras1443693bhangra_s
candygrams1952003candygrams
cantraps12319113cantraps
congrats11311433congrats
diagrams1246133diagrams
engram9310653_engram_
epigrams1346113epigrams
ethograms1545433ethograms
fangas105017193fang_a_s
gangrels1094973gangrels
gangways1643733gangways
genograms1345623genograms
ginghams1573893ginghams
grams85327313___grams
grograms1246023grograms
hangars114313493hang_ars
hangtags1344163hangtags
isograms1146473isograms
jagras1438463ja_gra_s
landgrabs1342863landgrabs
langrage10106033langrage
langrages11105903langrages
langrels9106173langrels
lingams104510193ling_ams
mailgrams1443633mailgrams
mangas94122923mang_a_s
mantram114011603mantram_
mantraps12298063mantraps
mantras93815863mantra_s
marrams11310123ma_rrams
monograms1478263monograms
nanogram1145673nanogram_
pangas99921103pang_a_s
panorama1244943panorama
panoramas1344273panoramas
pingrass1146003pingrass
programs1339783programs
raygrass1242883raygrass
renograms1246763renograms
sangars83116253sang_ars
sangas75222653sang_a_s
sangrias938373sangrias
sonograms1296303sonograms
stingrays1342713stingrays
tagrag837043ta_gra_g
taigas73712563taig_a_s
tallgrass1042833tallgrass
tamaraos10105883tamaraos
tamaraus1096183tamaraus
tanbarks1445563tanbarks
tandems1037633tan_dems
tanga64923693tang_a__
tangelos935743tangelos
tangents938713tangents
tanglers92911973tanglers
tangles83920043tang_les
tangos74216303tang__os
tangs65028343tang___s
tankards1366253tankards
tankas104613763tan_ka_s
tanrecs934823tan_recs
tantaras8269543tantaras
tantra63713353tantra__
tantrism1048373tantrism
tantrisms1146323tantrisms
tantrum946683tantrum_
tanyards1276183tanyards
tarama8412733ta__rama
taramas9612703ta__ramas
telegrams1244983telegrams
thirams1236823t_hirams
tomograms1445893tomograms
tonearms1044713tonearms
tongas74315523tong_a_s
trams75327673t___rams
trangam1039353trang_am_
trigram1077763trigram_
tundras857113tundra_s
venograms1545473venograms
wangans1149503wang_ans
yantras10259003yantra_s

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.423422437.4
2DLD Change Limit1461621037.48319532.5
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.95222471.2
 
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.