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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

48 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
germen961231(None) 
german9611981german
germens1078621germens
mermen10813811mermen
airmen82612352airmen
barmen105418532barmen
berme96022942berme_
bermed115217722bermed
bermes106023002bermes
carmen104019342carmen
cermet10321152cermet
cerumen1147762cerumen
ferment12315572ferment
gagmen103910412gagmen
garden84215082garden
garment10315232garment
gasmen93111562gasmen
gemmed12329572gemmed
gerent73223092ger_ent
germ75428962germ__
germane1049662germane
germans1079472germans
germier10309542germier
germina1038492germina
germs85118872germ_s
germy115113662germ_y
gleemen1035722gleemen
gorhen1038892gorhen
gormed105013832gormed
green65522142g_reen
gunmen9348722gunmen
herdmen13238452herdmen
kermes124616132kermes
legmen939342legmen
merman10513862merman
overmen12311802overmen
penmen10311492penmen
permed115217352permed
premen105017802premen
seamen84518562seamen
semen75724102se_men
sermon8413552sermon
tegmen988402tegmen
termed94816702termed
termer85717252termer
vermes115019142vermes
vermin113414522vermin
yeomen1138182yeomen

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit82551483.03027244.6
3Display Results48480.0331454.5
 (SQL Overall)178691483.42352203.0
 
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.