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

55 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
expunge174331(None) 
expunged1942971expunged
expunger1843191expunger
expunges1843571expunges
expanse16145602expanse
expense16127872expense
expulse1674512expulse
expungers1942692expungers
blunge94311483_blunge
effulge1442473effulge
enounce937573enounce
escuage1035113escuage
exchange21124323exchange
excuse1537423excu_se
exeunt1338703exeun_t
exhume1833803exhu_me
exine125518493ex_in_e
exing136016813ex_ing_
expand16236573expan_d
expanded19145163expanded
expander18145803expander
expands17195733expands
expanses17156173expanses
expend16247503expen_d
expended19136543expended
expender18136843expender
expends17217083expends
expensed18126413expensed
expenses17138373expenses
expiate16910593expiate
expire1538023exp_ire
explode1745963explode
explore1646613explore
expose1549523exp_ose
expound1744373expoun_d
expounded2042973expounded
expounder1943273expounder
expounds1843233expounds
expulsed1863613expulsed
expulses1774813expulses
expunging2042833expunging
expurgate1943823expurgate
exude134010293ex_u_de
grunge8359583_grunge
impinge12427503impinge
lounge75211213_lounge
lunge65323803__lunge
plunge93811053_plunge
pung75429633__pung_
pungle94413573__pungle
pungs85422223__pungs
purge85324603__purge
replunge1143963replunge
sponge939663_sponge
spurge93711323_spurge

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.403443402.0
2DLD Change Limit134027556.39320964.6
3Display Results55550.0134230.8
 (SQL Overall)178691556.80926243.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.