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

93 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
mirin7502315(None) 
miri66730371miri_
miring93723801miring
mirins83918901mirins
airing74927502airing
airn46433832air_n
amidin94015662amidin
brin67038192_brin
burin75626062burin
citrin82615402citrin
fibrin1138532fibrin
ficin103516722ficin
firing104021722firing
firkin1337822firkin
firn76927502fir_n
girn56026862gir_n
giron66118992giron
grin55733722_grin
hiring104421602hiring
irid55927172_irid
iring66025422_iring
iris45732552_iris
iron46728462_iron
kinin94917322kinin
kirn87123432kir_n
linin58025522linin
lipin75518892lipin
liri45128252liri_
main65345512m_ain
margin94016842margin
maria75032882maria
marina84623412marina
marine84230402marine
marlin84220902marlin
martin84122522martin
matin75132852matin
mavin105722952mavin
merino8315092merino
merit7339182merit
merlin83916682merlin
micron103714282micron
midi75628472midi_
midis85923412midis
midrib1138242midrib
mien65028362mi_en
miking134218462miking
mikron12318502mikron
milia72719572milia
mimic111414322mimic
miming114317262miming
mini65634552mini_
minim97321602minim
mining94225452mining
minion83416242minion
minis75432992minis
mir57046772mir__
mire66748232mir_e
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918362mirier
mirk106729502mir_k
mirks115122142mirks
mirky146315522mirky
mirs66940572mir_s
mirth106418892mirth
miry96326752mir_y
mirza16410442mirza
mitis75425992mitis
mitring103514142mitring
mixing164713942mixing
mizen164815272mizen
morion86217732morion
morn66237562mor_n
moron76925422moron
mucin93116822mucin
murein8311762murein
murid84520582murid
murine84220022murine
muring95120372muring
pirn67128372pir_n
purin75527592purin
ricin74620212ricin
rin36663182__rin
sarin55239252sarin
serin55434442serin
siren54525822siren
siring75128312siring
tiring74023092tiring
virgin1038082virgin
virid94116042virid
virion9310682virion
wiring104521022wiring

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 Filter178691538000.203880251.2
2DLD Change Limit53800931.98327130.6
3Display Results93930.0332818.2
 (SQL Overall)178691932.21980527.7
 
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.