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

61 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
laundries104556(None) 
foundries1345692foundries
gauntries1046032gauntries
laundress1042812laundress
maundies1137852maund_ies
sundries9312022_sundries
auguries947933_auguries
aunties73920073_aun_ties
bandies104124863ba_nd_ies
bawdries14136843ba_wdries
boundaries1345113boundaries
canaries10318943ca_naries
candies104125613ca_nd_ies
canneries11313083canneries
causeries11510643causeries
cauteries11615393cauteries
countries11313613countries
dandies94121443da_nd_ies
dauberies1248033dauberies
daubries1136743dau_bries
flaneries1249563fla_neries
gantries91413783ga_ntries
gauderies1147743gauderies
gaudies9311973gau_d_ies
jaundices1942183jaundices
kauries113613193kau__ries
laddies93715053la__ddies
ladies75124883la__d_ies
landlines1039763la_ndlines
landsides11116743la_ndsides
laniaries9411213laniaries
lapidaries1345063lapidaries
launces9329003laun__ces
launches1387903laun_ches
launder8309143laund__er
laundered1185023laundered
launderer1094513launderer
launderers1183873launderers
laundering1245183laundering
launders9358743laund_ers
laundresses1243113laundresses
laundrettes1251943laundrettes
laundry1133513laundr__y
laundrymen1651413laundrymen
legendries1243823legendries
lindies8416583l_ind_ies
lunacies1038013l_unacies
lunies64723013l_un__ies
luxuries1544793l_uxuries
mandrils1138493ma_ndrils
pandies104224503pa_nd_ies
panfries13149203pa_nfries
pantries101817393pa_ntries
quandaries2064413quandaries
randies84225663ra_nd_ies
sauries72821623sau__ries
tanneries9310423tanneries
tawdries12136083ta_wdries
undies73821963__und_ies
undried92314613__undried
updries10209083__updries

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.453394461.4
2DLD Change Limit148641616.75022020.9
3Display Results61610.0302033.3
 (SQL Overall)178691617.23324705.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.