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

100 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
milliard114703(None) 
billiard1145871billiard
milliards1246191milliards
milliare1039151milliare
milliary1346851milliary
billiards1245022billiards
galliard10125752galliard
halliard12125962halliard
mallard10310272mall_ard
miliary1249462mi_liary
millboard1444652millboard
milliares1149402milliares
millibar1275352millibar_
millibars1365562millibars
millier93716702millier_
milliers102611902milliers
milliped1337382milliped
willyard1543962willyard
ballyard1445893ballyard
biliary1238213bi_liary
billboard1444713billboard
bollard103210503boll_ard
ciliary1247923ci_liary
collard103712923coll_ard
dullard936603dull_ard
filliped1435223filliped
filmcard1642823filmcard
galliards1194543galliards
gillied95512313gilli_ed
goliard936073_goliard
halliards13104933halliards
hillier103413963hillier_
hilloaed12136923hilloaed
iliad64613463_i_lia_d
liard65418593___liard
mallards1138323mall_ards
midland1136613midl_and
milia72719573mi_lia__
miliaria1048783mi_liaria
military1347233military
milkier133411163milkier_
milkmaid1742683milkmaid
millage103112753mill_age
millboards1544093millboards
millcake1644653millcake
milldam1245473millda_m
milldams1344633milldams
milled94326173mill__ed
millenary1444583millenary
milleped1335173milleped
miller84625413mill_er_
millers93621343mill_ers
milliaries1248243milliaries
millieme12276803millieme
milligal1145703milligal
milligals1245033milligals
milligram1443903milligram
millilux1742933millilux
millime112511403milli_me
millimes122411373millimes
millimho1543473millimho
milline92519113milli_ne
milliner102811863milliner
milliners11289953milliners
millinery14336103millinery
millines102718063millines
milling103223683milli_ng
millings113712583millings
milliohm1544443milliohm
million91813143milli_on
millions101712433millions
millipede1444223millipede
millipeds1444703millipeds
millirem1245693millirem
milliwatt1444773milliwatt
millpond1344143millpond
millrace1245433millrace
millwork1745523millwork
milord999573mi_l_ord
miltier93214963miltier_
misaward1464593misaward
misheard1446253misheard
mislaid1039303misl_aid
mislead10419973mislea_d
misleared1277453misleared
mislearn1045343mislearn
misliked15319513misliked
mislived14328783mislived
oilbird1043743oilbi_rd
paillard1146263paill_ard
pilchard1644553pilchard
pillar8314023pill_ar_
pillared11228093pill_ared
pillars9313493pill_ars
pollard103511143poll_ard
sillier74017593sillier_
tiltyard1262933tiltyard
wildcard1543643wildcard
willied114611563willi_ed
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.423422437.4
2DLD Change Limit1461621007.15620425.1
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.62523434.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.