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

57 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
pongee9492019(None) 
congee96024471congee
ponged105619351ponged
pongees104212541pongees
apogee9312562apo_gee
bonged105719602bonged
bungee96319772bungee
conge85227592cong_e
congeed113212312congeed
congees103517922congees
conger95024272conger
conges94928172conges
donee66931012don_ee
dongle83612492dongle
donnee74317062donnee
gonged97115912gonged
longe66626462long_e
longed87121372longed
longer75823202longer
longes75925572longes
lungee75119812lungee
monger94418332monger
mongoe94214982mongoe
ogee57629882_o_gee
panged104722332panged
pangen94115912pangen
pangene102711962pangene
pensee8417312pensee
pinged104321382pinged
pinger94324092pinger
pogey116017892po_gey
pollee83623272pollee
pommee122813282pommee
ponce95222512pon_ce
ponced114314812ponced
ponces104720842ponces
ponded105218772ponded
ponder94521692ponder
pone65747532pon__e
pones74547042pon_es
pong76231142pong__
pongid104111582pongid
pongs85526342pong_s
ponied94920702ponied
ponies84833462ponies
pontes83627852pontes
pronged113912392pronged
pungle94413572pungle
spondee10310592spondee
sponge939662spong_e
sponged1137952sponged
sponger1038522sponger
sponges10311042sponges
tonged86518902tonged
tonger74719682tonger
tongue7410092tongue
yogee9518062yo_gee

Search took 3 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.343520965.0
2DLD Change Limit82551572.47033421.5
3Display Results57570.0163562.5
 (SQL Overall)178691572.82963164.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.