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

59 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
lowriders134318(None) 
lowrider1234151lowrider_
cowriters14317282cowriters
joyriders2042232joyriders
lorimers1036612lo_rimers
loriners839962lo_riners
lowlifers1542952lowlifers
boarders11408623boar_ders
borders104317533bo_r_ders
borides10515153bo_ride_s
bowlders14306493bow_lders
clowders14357473clow__ders
codrivers1544863codrivers
colliders12298073colliders
confiders1537483confiders
considers1238933considers
corders104520883co_r_ders
corridors1245073corridors
couriers103213173couri_ers
cowhides1736013cowhide_s
cowries124218013cowri_e_s
cowriter13238883cowriter_
cowrites133011593cowrite_s
deriders102411853_deriders
dowries114413983dowri_e_s
hagriders1443553hagriders
hoarders12307433hoar_ders
horrider1236533horrider_
joyrider1942663joyrider_
joyrides1943853joyride_s
larders83516943l_ar_ders
lawgivers1641793lawgivers
loaders83413433lo__aders
loiters74116613lo__iters
lories64933043lo_ri_e_s
lorimer937753lo_rimer_
loriner7511893lo_riner_
lorises73918593lo_rise_s
lorries74518353lorri_e_s
lowers94624923low___ers
lowlanders1442693lowlanders
lowlier10338903lowli_er_
lowlifer1443283lowlifer_
lowlifes1434333lowlife_s
lowliness1236403lowliness
lowlives1434573lowlive_s
nonwriters1345093nonwriters
orders74315993_o_r_ders
outriders10237223outriders
postriders1344853postriders
powders134111553pow__ders
rewriters1236343rewriters
riders74123903___riders
striders94412123_striders
topsiders1243023topsiders
torrider936173torrider_
voiders11279823vo__iders
worriers11257813worri_ers
writers105513493__writers

Search took 7 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.486367677.0
2DLD Change Limit148641596.32623496.8
3Display Results59590.0163687.5
 (SQL Overall)178691596.82826170.3
 
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.