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

75 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
milliary134685(None) 
miliary1249461mi_liary
milliard1147031milliard
milliare1039151milliare
biliary1238212bi_liary
billiard1145872billiard
ciliary1247922ci_liary
military1347232military
millenary1444582millenary
milliards1246192milliards
milliares1149402milliares
millibar1275362millibar_
millibars1365572millibars
millier93716702millier_
milliers102611902milliers
millinery14336102millinery
armillary1443913armill_ary
axillary18235103axill_ary
billiards1245023billiards
colliery13307363colliery
galliard10125753galliard
halliard12125963halliard
hillier103413963hillier_
mallard10310273mall_ard
maxillary2143443maxill_ary
milady1236613mi_l_ady
milia72719573mi_lia__
miliaria1048783mi_liaria
milkier133411163milkier_
milkily16216553milki_ly
millage103112753mill_age
millboard1444653millboard
millcake1644653millcake
milldam1245473millda_m
milldams1344633milldams
miller84625413mill_er_
millers93621343mill_ers
milliaries1248243milliaries
millieme12276803millieme
milligal1145703milligal
milligals1245033milligals
milligram1443913milligram
millihenry1851923millihenry
millilux1742933millilux
millime112511403milli_me
millimes122411373millimes
millimho1543473millimho
milline92519113milli_ne
milliner102811863milliner
milliners11289953milliners
millines102718063millines
milling103223683milli_ng
millings113712583millings
milliohm1544443milliohm
million91813143milli_on
millions101712433millions
milliped1337383milliped
millirem1245693millirem
milliwatt1444773milliwatt
millrace1245443millrace
millwork1745523millwork
miltier93214963miltier_
mimicry1643493mi_micry
mislay113510683misl_a_y
mislearn1045343mislearn
missilry1344653missilry
mollify1555503molli_fy
pillar8314023pill_ar_
pillars9313493pill_ars
pillory12247453pill_ory
sillier74017593sillier_
sillily10209783silli_ly
villainy1444883villainy
willyard1543963willyard
willyart1445403willyart

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 Filter1786911461620.436409841.7
2DLD Change Limit146162756.94021060.8
3Display Results75750.0302500.0
 (SQL Overall)178691757.40624127.9
 
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.