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

62 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
mirroring124619(None) 
marrowing1546662marrowing
minoring11311472mi_noring
armoring1149123_armoring
arrowing1237943_arrowing
birring103713063bi_r_ring
borrowing1544563borrowing
burrowing1544473burrowing
carroming1437683carroming
corroding1337943corroding
disrobing1347703disrobing
farrowing1645873farrowing
furrowing1644063furrowing
garroting1136953garroting
harboring1538263harboring
harrowing1646433harrowing
ignoring1036483_ignoring
imploring1445573imploring
improving1745413improving
ironing82414013_i_roning
liquoring1943703liquoring
majoring1836363m_ajoring
marooning1238593marooning
marring103319553m_ar_ring
marrying14157223marr_ying
martyring1535783martyring
mentoring1239543mentoring
miaouing1134893mi_aouing
miaowing1434593mi_aowing
micromini1546593micromini
migrating13910533migrating
mimeoing1336143mimeo_ing
miring93723803mi___ring
mirror848003mirror___
mirrored1145773mirror_ed
mirrorlike1651573mirrorlike
mirrors938623mirror__s
miscoding1538183miscoding
misdoing1238803misdo_ing
misfiring1536973misfiring
misforming1845403misforming
misgrowing1744633misgrowing
mismoving1745783mismoving
misrating121014853misrating
misrouting1347223misrouting
misruling1237493misruling
missorting1347123missorting
miswording1744863miswording
misyoking1944923misyoking
mitering113015403mi_tering
mitring103514143mi__tring
mooring102514443m__ooring
mortaring1237943mortaring
motoring11410953m_otoring
murdering1357133murdering
murmuring1443633murmuring
narrowing1345603narrowing
parroting1239153parroting
sorrowing1344873sorrowing
visoring1238373vi_soring
vizoring2134573vi_zoring
yirring11307763yi_r_ring

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 Filter1786911486410.483369960.7
2DLD Change Limit148641626.81321817.3
3Display Results62620.0163875.0
 (SQL Overall)178691627.31224438.0
 
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.