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 “misfiling” 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
misfiling153722(None) 
misfiring1536971misfiring
misaiming1437872misaiming
misbilling1545542misbilling
misciting1439672misciting
misdialing1446262misdialing
misfielding1842722misfielding
misfitting1645532misfitting
misgiving1645592misgiving
misliking1637112misliking
misliving1546982misliving
misruling1237492misruling
mistiming1438912mistiming
mistitling1346222mistitling
abseiling1265343abseiling
assailing1036023assailing
assoiling1045353assoiling
besmiling1436263besmiling
defiling132812463_defiling
disabling1337753disabling
discipling1645873discipling
disliking1537313disliking
distilling1247793distilling
ensiling9410723ens_iling
filing103823763___filing
infixing1936103_infixing
isling71213883_is__ling
mailing102923343m__ailing
miauling1137343mi_auling
middling13249343mi_ddling
midwifing1942963midwifing
midwiving1942623midwiving
miffing16298403mi_f_fing
milling103223683mi__lling
mingling122010933mi_ngling
minifying1845823minifying
misacting1439083misacting
misadding14115833misadding
misalign1146433mis_align
misallying1644313misallying
misbiasing1545203misbiasing
misbinding1645063misbinding
misbuilding1742733misbuilding
miscalling1547863miscalling
miscoding1538183miscoding
miscoining1597763miscoining
miscuing1338733mis_cuing
misdating131010663misdating
misdealing1457363misdealing
misdefining1843313misdefining
misdialling1543303misdialling
misdoing1238803mis_doing
misdriving1745163misdriving
miseating121215433miseating
misediting1446573misediting
misfeeding1744993misfeeding
misfile122611553misfil__e
misfiled14278653misfil_ed
misfiles133110983misfil_es
misforming1845403misforming
misframing1846233misframing
misgivings1742413misgivings
misguiding1544343misguiding
mishitting1645993mishitting
misjoining2085293misjoining
miskicking1844243miskicking
mislaying1557913mislaying
mislying1437843mis_lying
mismaking18118023mismaking
mismating141211823mismating
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
mispoising1546583mispoising
mispricing1746713mispricing
misprizing2447533misprizing
misraising1348123misraising
misrating121014853misrating
misrelying1645503misrelying
missaying1537633missaying
missing103619073mis__sing
missioning1347403missioning
misstyling1643833misstyling
missuiting1356743missuiting
mistaking1699693mistaking
misting103623383mis__ting
mistuning1237673mistuning
mistyping1744723mistyping
misusing1138893mis_using
misvaluing1684603misvaluing
miswriting1646843miswriting
misyoking1944923misyoking
mizzling19255443mi_zzling
moiling103417663m__oiling
muffling1765503m_uffling
muscling1337853mus_cling
piffling1745133pi_ffling
pistoling1268493pistoling
prefiling1549533prefiling
profiling1548233profiling
refiling123116533_refiling
resailing103314253resailing
resiling93520173res_iling
riffling1556113ri_ffling
rifling112815013ri_f_ling
sailing83927373__sailing
smiling103915443__smiling
soiling83422323__soiling
spiling102919703__spiling
tiffining1642913tiffining
unsmiling1256873unsmiling
visiting1238393vis_iting

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 Filter1786911486410.403443402.0
2DLD Change Limit1486411126.22023897.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.66926794.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.