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

75 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
pfennig136228(None) 
pfennige1461821pfennige
pfennigs1461981pfennigs
peening103318302peening
penni74617902p_enni_
pennia84412972p_ennia
penning103616492p_enning
pennis84315742p_ennis
benni74715363_benni_
bennis84314803_bennis
biennia994933biennia
denning93515173_denning
evening11310223evening
fanning113615073_fanning
feeing104416503_feeing
fencing132411133_fencing
fending123717603_fending
fennec11326913_fennec
fennel9429473_fennel
fennier10339253_fennier
fenny115115133_fenn_y
feting104417793_feting
feuing104412273_feuing
fining104223213_fining
finning113615113_finning
funning113813613_funning
keening123713153keening
kenning124010543_kenning
omening10310093omening
opening1039923opening
paining103920243paining
panning104019393p_anning
pawning134711413pawning
peeing94618083peein_g
peeking144414953peeking
peeling102919873peeling
peeping123615213peeping
peering103520353peering
peeving135112243peeving
peining104619153p_eining
penang92511113p_enang
pencil103712973p_encil
pending114119773p_ending
penis75129323p_e_nis
penna74520203p_enn_a
pennae84314033p_ennae
penne75423853p_enn_e
penned94217613p_enned
penner84616663p_enner
pennies94218813p_ennies
pennine93712953p_ennine
pennon8310643p_ennon
penny105119453p_enn_y
pensil83013333p_ensil
pernio8513143p_ernio
phenix1837133phe_nix
phoning13312053phoning
piecing12410453piecing
pieing93917653piein_g
pining93726533p_ining
pinning103417853p_inning
planing103418253planing
planning113610223planning
pleonic1139433pleonic
preeing103817673preeing
preening113115843preening
preying133114553preying
pruning10311733pruning
punning103414993p_unning
renig64518913_re_nig
rennin63914033_rennin
sennit63117923_sennit
tennis64015303_tennis
weening114113973weening
yenning11369493_yenning

Search took 7 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.390458182.1
2DLD Change Limit134027755.61023890.7
3Display Results75750.0302500.0
 (SQL Overall)178691756.03029633.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.