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

87 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
merger9501648(None) 
meager94515201meager
mercer105214201mercer
merer75126231mer_er
merge84523691merge_
merged104214951merged
mergee94018141mergee
mergers103813421mergers
merges94122491merges
serger73819741serger
verger104315701verger
aerier64823162aerier
amercer1146372amercer
bergere1068912bergere
burger94020792burger
demerger12127372demerger
eager65526972_eager
edger75215952_edger
eerier64320022eerier
eger55923572_e_ger
egger74414412_egger
emerge91510462emerge_
emerged11158212emerged
emerges101310882emerges
forger104820772forger
gorger86116982gorger
hedger114912652hedger
herder104516462herder
jerker17369042jerker
kegger12388082kegger
larger74417512larger
ledger85914392ledger
leger65721512le_ger
manger94325012manger
marge85328332marge_
marges94525712marges
marker124420392marker
marrer83716672marrer
mauger93813482mauger
meagre9349322meagre
meaner84617842meaner
meeker12359982meeker
meeter83616502meeter
melder93915812melder
melter83520112melter
member12258852member
mender93520792mender
mercers114412772mercers
mercery14397622mercery
merces105720742merces
merde84320122merde_
merdes94518602merdes
mere67244442mer_e_
meres75143572mer_es
mergees104411232mergees
merle75824372merle_
merles85322762merles
mermen10813812mermen
merrier92612302merrier
meter75130322me_ter
metier83517692metier
mewler113510232mewler
mirier83918362mirier
mirker123712692mirker
monger94418332monger
morgen9312202morgen
mugger103914702mugger
murder93613782murder
murker123715242murker
perter84422282perter
purger94717232purger
serer55935512ser_er
serge64727472serge_
serged84118772serged
sergers83815632sergers
serges74225972serges
server94917712server
surger74320092surger
termer85717252termer
terser67317822terser
urger64116472_urger
verge93419842verge_
verged114815162verged
vergers114412632vergers
verges104320182verges
verier94620962verier
verser94516962verser

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.626285448.9
2DLD Change Limit82551872.70330540.5
3Display Results87870.0302900.0
 (SQL Overall)178691873.35953197.7
 
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.