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

94 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
missing10361907(None) 
dissing94517681dissing
hissing114213141hissing
kissing122911051kissing
massing104318021massing
messing103916391messing
misting103623381misting
misusing1138891misusing
mossing103915421mossing
mussing104015541mussing
pissing103914801pissing
wissing113212941wissing
amassing1138002amassing
biasing103512452biasing
biassing11307262biassing
blissing1136872blissing
bossing103714602bossing
bussing103614622bussing
cessing103814812cessing
cussing103814272cussing
discing113914592discing
dishing124017102dishing
disking134615492disking
disusing1039012disusing
dossing93313272dossing
fessing113812862fessing
fishing143913862fishing
fisting113818122fisting
fussing113611682fussing
gassing94216332gassing
hissings12556752hissings
histing113720372histing
isling71213882_isling
issuing836052_issuing
jessing153710622jessing
lisping103412752lisping
listing84020592listing
mashing134422242mashing
masking145116612masking
masting104325822masting
mensing103915102mensing
meshing134513812meshing
miching152911802miching
miffing16298402miffing
miking134218462mi_king
milding113615452milding
milking143712762milking
milling103223682milling
milting103619122milting
miming114317262mi_ming
mincing123314332mincing
minding113317892minding
mining94225452mi_ning
minting103020812minting
miring93723802mi_ring
misbind1258272misbind
miscuing1338732miscuing
misdoing1238802misdoing
mislying1437842mislying
missaying1537632missaying
missend104411372missend
missent94318712missent
missies93423982missies
missile92815402missile
mission9312742mission
missions10311902missions
missis84417502missi_s
missive122413142missive
mitring103514142mitring
mixing164713942mi_xing
moshing134214882moshing
mousing103816272mousing
moussing1138142moussing
mushing134217632mushing
musing93919502m_using
musting103221072musting
passing104318422passing
pishing134314372pishing
prissing113011452prissing
rinsing82516112rinsing
rising74025882ri_sing
risking123914242risking
sassing84615552sassing
sussing84013702sussing
tissuing935102tissuing
tossing83612562tossing
visaing11279332visaing
viseing11299162viseing
vising103915872vi_sing
wishing144114892wishing
wising103318222wi_sing
wisping133711942wisping
wisting113519742wisting
yessing113210062yessing

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 Filter1786911076710.406440125.6
2DLD Change Limit107671942.90637051.3
3Display Results94940.0303133.3
 (SQL Overall)178691943.34253468.3
 
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.