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

148 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
misgive1333903(None) 
misgave13298281misgave
misgiven14245901misgiven
misgives14329291misgives
mislive122812691mislive
missive122413141missive
emissive1345922emissive
massive12289772massive
miscite11314382miscite
misdrive1446682misdrive
misfile122611552misfile
misfire12229892misfire
misguide12145702misguide
mislie83219152misli_e
mislike132914832mislike
mislived14328782mislived
mislives132912152mislives
mismove1437082mismove
missile92815402missile
missives133212842missives
mistime11312612mistime
omissive1345102omissive
visive1257872vis_ive
admissive1543023admissive
amusive1246253amus_ive
biggie103810933biggi_e
costive12312843costive
disguise1046833disguise
dislike122913453dislike
dissave1139413dissave
festive1339773festive
fictive1537023fictive
fissile10269653fissile
forgive1436193forgive
gingiva1253293gingiva
gingivae1352173gingivae
give85829353___give
imagine1037883imagine
jussive1734293jussive
mashie11315933mashi_e
midge95016553midg__e
midlife13248303midlife
midline102315103midline
midlives14287463midlives
midsize1946393midsize
midwife16225523midwife
midwived18263553midwived
midwives17274803midwives
miggle104012113mi_ggle
millime112511403millime
milline92519113milline
mingier103815293mingier
mingle93518783ming_le
miniver1238393mi_niver
misaim10311853misai_m
misaimed1338093misaimed
misaims11310113misaims
misate81222693mis_ate
misaver1249813mis_aver
misbias1139083misbias
misbill1137033misbill
misbind1258273misbind
miscible1447673miscible
miscited13310423miscited
miscites12313783miscites
miscode12310413miscode
miscue10412223mis_cue
misdate101413963misdate
misdial1039643misdial
misdid10510573misdi_d
misdivide16103793misdivide
misdone10310863misdone
misdriven1544073misdriven
misdrives1546213misdrives
misdrove1445433misdrove
mise66043583mis___e
misease92713043misease
misfiled14278653misfiled
misfiles133110983misfiles
misfired14238543misfired
misfires132210583misfires
misfit112813833misfi_t
misfits12279663misfits
misgauge1244253misgauge
misgiving1645593misgiving
misgovern1543063misgovern
misgrade1247503misgrade
misgrew1335523misgrew
misgrow1344433misgrow
misguided14144653misguided
misguider13174343misguider
misguides13165333misguides
mishit112618203mishi_t
mishits122513083mishits
miskick1435613miskick
mislies92922283mislies
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislit83019693misli_t
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
mismoved1635653mismoved
mismoves1537293mismoves
misname11119483misname
mispage12310523mispage
mispoise1248263mispoise
misprice1448133misprice
misprize2147543misprize
misraise10410523misraise
misrate91319143misrate
misrule939353misrule
missies93423983missies
missiles103015083missiles
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
mistake131312623mistake
mistier93418713mistier
mistily122612343mistily
mistimed1339123mistimed
mistimes12612613mistimes
misting103623383misting
mistitle1038523mistitle
mistune9310653mistune
mistype14126523mistype
misuse83213643mis_use
miswrite1348923miswrite
misyoke1635823misyoke
moggie103210103moggi_e
motive113112143m_otive
muskie123412543muski_e
muspike1536043muspike
ogive9379093__ogive
outgive11199253outgive
passive12239593passive
piggie103210773piggi_e
piscine11610973piscine
pismire1135353pismire
regive104814323_regive
remissive1445773remissive
restive10315933restive
shive114423423__shive
skive124614113__skive
swive115316193__swive
tussive1035303tussive

Search took 8 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.440406115.9
2DLD Change Limit1340271487.48317910.9
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.98622375.5
 
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.