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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

49 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
mimetite124760(None) 
mimetites1346821mimetites
mimetic1338642mimeti_c
appetite1258493appetite
bimbette1444753bimbet_te
biotite9311033bi_otite
cementite13147113cementite
dimerize2048113dimerize
dinette8310013dinet_te
emetine9712943_emetine
fumette1245523fumet_te
hematite131612153hematite
homesite1359263homesite
ilmenite1046223ilmenite
imitate9310873_imitate
immediate1444303immediate
immotile1245173immotile
lifetime1343983lifetime
limonite1048163limonite
magnetite127311213magnetite
memetics1447803memetics
metate82720533__metate
militate10311673militate
millerite1148403millerite
mimeoing1336143mimeoing
mimesis1137323mimesi_s
mimesises1345363mimesises
minutiae1045583minutiae
miscite11314383mi_scite
misedit10311043misedit_
misedited1346783misedited
misedits1147963misedits
misstate10711333misstate
mistime11312613mi_stime
mistitle1038523mi_stitle
miswrite1348923miswrite
mofette1296773mofet_te
monetise10311473monetise
monetize1949983monetize
mozette1886773mozet_te
musette938433muset_te
petite84320653__petite
pipette1137943pipet_te
siderite9411363siderite
sienite7312713si_enite
smectite1245773_smectite
sometime1246743sometime
timeline1039243timeline
vidette1167543videt_te

Search took 10 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.186960704.3
2DLD Change Limit146162498.86016496.8
3Display Results49490.0301633.3
 (SQL Overall)178691499.07619688.3
 
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.