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

54 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
germander134536(None) 
germanders1444601germanders
demander12238722de_mander
geomancer1443752geomancer
germane1049662german_e_
gerrymander1861412gerrymander
grander93315872g_r_ander
brander103915823_br_ander
commander16127403commander
coriander1245663coriander
demanded13348513de_manded
demanders13247573de_manders
deranger1037353der_anger
emender10649843_e_mender
expander18145803_expander
fermenter1497543fermenter
gander84322763g___ander
garlanded1244693garlanded
gender83517933ge___nder
geomancers1542953geomancers
german9611983german___
germanely1543993germanely
germanic1367503german_ic
germanium1445023germanium
germanize2148263germanize
germanized2347133germanized
germanizes2248153germanizes
germans1079473german__s
germier10309543germ__ier
gerrymanders1961313gerrymanders
goosander1143253goosander
gormand1157453gormand__
gormandizer2483573gormandizer
gormands1266563gormand_s
grader84919693g_r_a_der
grandee93115513g_r_andee
grandeur10305673g_r_andeur
granger93514213g_r_anger
granter84117133g_r_anter
grinder93312393g_r_inder
groaner82510133g_roan_er
grounder1047613g_rounder
hereunder1343183hereunder
meander1049973me__ander
merganser1242853merganser
netminder1242513netminder
normande1145943normande_
pervader1444863perva_der
pomander1347083_pomander
remainder1244683re_mainder
remanded123011323re_manded
reminder113110513re_minder
serenader10216003serenader
strander97112063str_ander

Search took 10 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.470380193.6
2DLD Change Limit148641548.60617271.8
3Display Results54540.0331636.4
 (SQL Overall)178691549.10919617.0
 
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.