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

92 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
dunces9521575(None) 
dances95120651dances
duces86327471du_ces
dunce86319261dunce_
dunches133312581dunches
dunes65332171dun_es
ounces83617771ounces
bedunces1345512bedunces
bounces113813682bounces
bunches144116032bunches
buncos104011592buncos
daces85030682d_aces
dance85223132dance_
danced105315252danced
dancer94817612dancer
dancers103413092dancers
deices94119372deices
denes65639722den_es
denies74729642denies
deuces94015512deuces
dices86434242d_ices
dines66449152din_es
dinges83825422dinges
donees74519492donees
duce76933502du_ce_
ducks124823212du_cks
ducts85319892du_cts
dudes75424372du_des
duendes938192duendes
dues56045502du__es
dukes105023472du_kes
dulcet9314492dulcet
dulcets1046282dulcets
dulses73913652dulses
dunams937832dunams
dunch115316262dunc_h
duncish1335792duncish
dune56137582dun_e_
dunged95414692dunged
dungs75821972dun_gs
dunites8313592dunites
dunked124315282dunked
dunker113616462dunker
dunkers123512192dunkers
dunks105621192dun_ks
dunned85015522dunned
dunner73913822dunner
dunness8298982dunness
dunnest83312262dunnest
duns55140432dun__s
dunted84718502dunted
dunts65828412dun_ts
dupes86425932du_pes
durances1158682durances
dures65635922du_res
duties74921902duties
dynes95917582dyn_es
educes94011952edu_ces
fences114617112fences
hances115621282hances
hunches153913462hunches
jaunces16307422jaunces
jounces16369852jounces
juices1549422juices
juncoes16338072juncoes
juncos15449232juncos
lances84824102lances
launces9329002launces
luces75528432lu_ces
lunches124115442lunches
lunes55337772lun_es
lunges76123422lunges
lunies64723012lunies
minces104420802minces
munches144215792munches
nances83618642nances
nonces84418832nonces
nuances938522nuances
nuncles939842nuncles
ounce77019932ounce_
ponces104720842ponces
pounces114113892pounces
puces94924632pu_ces
punches144816132punches
quinces183210432quinces
rances84625442rances
runes55530222run_es
tunes55332192tun_es
uncles8317162_uncles
uncos74117032_uncos
uncus74014982_uncus
winces114819112winces

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.1061685764.2
2DLD Change Limit82551922.66031034.2
3Display Results92920.0303066.7
 (SQL Overall)178691922.79663909.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.