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 “munition” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
munition103876(None) 
monition10311721monition
munitions1138171munitions
punition1038371punition
ammunition14103812ammunition
audition979172audition
function1337842function
ignition946532ignition
junction1736202junction
lenition8310082lenition
lunation8311922lunation
mention9314372men_tion
monitions11310882monitions
munitioned1353942munitioned
munnion935862mun_nion
muntin82915182mun_ti_n
mutation101412882mutation
punitions1137922punitions
tuition738822tu_ition
unction9310662_unction
addition1096893addition
admonition1344443admonition
adnation9310783adnation
agnation9311723agnation
amanitin1048463amaniti_n
ambition1246563ambition
ammunitions15113653ammunitions
auction93412933au_ction
auditions1078753auditions
bunion83111313bun__ion
cognition1247013cognition
coition9314313_coition
conation101420883conation
condition12411163condition
dentition1049633dentition
donation91513783donation
dunitic1048143duniti_c
duration9312693duration
edition8310853_edition
emanation11910783emanation
emulation11312393emulation
enation73419233_enation
erudition1046173erudition
fruition11106103fruition
functions1437743functions
gumption1343983gumption
ignitions1045803ignitions
ignitron943203ignitron
inanition947293inanition
inunction1146893inunction
junctions1835943junctions
lenitions939473lenitions
lunations9310723lunations
luxation1538233luxation
manikin132110243maniki_n
manito8518693manit_o_
manitos9314053manit_os
manitou938463manit_ou
mansion9611543man_sion
mediation12312293mediation
mentation11313983mentation
mentions10312893men_tions
minikin13258983miniki_n
minion83416243m__inion
monitive1349993monitive
monitor9310723monit_or
motion85217553m__otion
mullion91911173mu_llion
multipion1346103multipion
multiton1087343multiton
munitioning1453033munitioning
munnions1035273mun_nions
munting103718773mun_ting
muntins92715133mun_tins
musician1246693musician
mutations111211453mutations
mutilation1249753mutilation
muton73817003mu__t_on
mutton8510453mu__tton
nation64322803__nation
niton55418283__nit_on
notion64516583__notion
nunnation9126563nunnation
nutation81513103nutation
nutrition966733nutrition
petition10711753petition
position10912193position
premunition1545573premunition
punitive1346833punitive
pupation1269503pupation
question1745823question
quintin163810333quinti_n
rendition1058933rendition
ruction93611613ru_ction
ruination9311273ruination
sanction1049533sanction
sedition939333sedition
submunition1563113submunition
suction93713043su_ction
sudation9310803sudation
tuitions838283tu_itions
unctions1039733_unctions
union54519793_un__ion
unison649033_uni_son
unities72520153_unities
uniting8315823_uniting
unitive10310563_unitive
unitize16310033_unitize
venation11513503venation
vendition1345693vendition
volition1179173volition
zonation171410723zonation

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621126.39022873.6
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.85626063.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.