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

90 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
mirins8391890(None) 
mirin75023151mirin_
miring93723801miring
airing74927502airing
airings83913832airings
airns55521032air_ns
amidins103713092amidins
brins75533972_brins
burins84221892burins
citrins92614362citrins
fibrins1238632fibrins
ficins113513982ficins
firing104021722firing
firings114112322firings
firkins1437662firkins
firns86018542fir_ns
girns64516802gir_ns
girons75014372girons
grins65427222_grins
hiring104421602hiring
irids66417772_irids
iring66025422_iring
iris45732552_iri_s
irons55324132_irons
kinins104014582kinins
kirns95315452kir_ns
linins65922142linins
lipins85016882lipins
mains75635102m_ains
margins103815192margins
marina84623412marina
marinas93519372marinas
marine84230402marine
marines93928012marines
marlins93420472marlins
martins93322062martins
matins84527782matins
mavins115119182mavins
merino8315092merino
merinos9311972merinos
merits8320872merits
merlins93015802merlins
microns113814782microns
midis85923412midi_s
midribs1235502midribs
miens76118302mi_ens
miking134218462miking
mikrons13428412mikrons
mimics1289362mimics
miming114317262miming
minims104514812minims
mining94225452mining
minings103912072minings
minions93314622minions
minis75432992mini_s
mires75640882mir_es
miri66730372miri__
mirier83918362mirier
miriest93619822miriest
miriness10310462miriness
mirks115122142mir_ks
mirs66940572mir__s
mirths114912992mirths
mirzas1738172mirzas
mitis75425992miti_s
mitring103514142mitring
mixing164713942mixing
mizens174610252mizens
morions94014632morions
morns75527442mor_ns
morons84919542morons
mucins102712512mucins
mureins9310732mureins
murids93212192murids
murine84220022murine
murines93718222murines
muring95120372muring
pirns76020092pir_ns
purins83722652purins
ricins83618702ricins
rins46153192__rins
sarins63932622sarins
serins64029672serins
sirens65318152sirens
siring75128312siring
tiring74023092tiring
virgins1137862virgins
virions1039872virions
wiring104521022wiring
wirings113910102wirings

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit82551902.56332208.7
3Display Results90900.0303000.0
 (SQL Overall)178691902.71665792.0
 
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.