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

42 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
pomatum134639(None) 
pomatums1443791pomatums
omasum1035502_omasum
abomasum1441813abomasum
comate104124843comat_e
comates114123643comates
comatic131816943comatic
comatik15139723comatik
comatula1244263comatula
conatus9310463conatus
cymatium1743703cymatium
datum8310633__datum
erratum944513erratum
imaum9139643_ima_um
komatik12135203komatik
lomentum1244753lomentum
momentum1144433momentum
notum7611693no__tum
oakum1177313_o_akum
omentum1155933_omentum
papadum1475233papadum
pinetum1145553pinetum
podium112911913po_dium
pomace123111913poma_ce
pomaces132712123pomaces
pomade113611333poma_de
pomaded13377863pomaded
pomades123711733pomades
pompom1436493pom_pom
pompous1338063pompous
poppadum1452483poppadum
possum1057953po_ssum
potato8513433potat_o
pronotum1245143pronotum
solanum946403solanum
solatium1067613solatium
somata8312383somat_a
somatic111916473somatic
stratum9318253stratum
tomato8313453tomat_o
tomentum1244993tomentum
vomitus12215743vomitus

Search took 9 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.423422437.4
2DLD Change Limit134027427.65617506.1
3Display Results42420.0133230.8
 (SQL Overall)178691428.09222082.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.