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 “lowrider” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
lowrider123415(None) 
lowriders1343181lowriders
cowriter13238882cowriter
horrider1236532horrider
joyrider1942662joyrider
lorimer937752lo_rimer
loriner7511892lo_riner
lowlier10338902lowli_er
lowlifer1443282lowlifer
torrider936172torrider
acrider1038623_acrider
arider74717743__arider
blowier1248943blow_i_er
blowsier1335063blowsi_er
blowzier2233413blowzi_er
boarder103910323boar_der
border94419973bo_r_der
boride9415903bo_ride_
borides10515153bo_rides
bowlder13407473bow_lder
clowder13367933clow__der
codriver1435913codriver
collider113410413collider
confider1438123confider
consider11310393consider
corder94322883co_r_der
corridor1145033corridor
courier93617893couri_er
cowhide1636133cowhide_
cowhided1843743cowhided
cowhides1736003cowhides
cowier113616163cow_i_er
cowrie113814283cowri_e_
cowries124218013cowri_es
cowrite123612683cowrite_
cowriters14317283cowriters
cowrites133011593cowrites
derider93214973_derider
dowdier12328573dowdi_er
downier11299703downi_er
downriver1642663downriver
dowries114413983dowri_es
flowerier1544273floweri_er
forrader1236153forrader
gorier73719373go_ri_er
hagrider1334483hagrider
hoarder11329233hoar_der
hoarier104211743hoari_er
jowlier17327563jowli_er
joyride1853753joyride_
joyriders2042233joyriders
joyrides1943853joyrides
larder73720973l_ar_der
lardier83518343l_ardier
lawgiver1541943lawgiver
learier73415663leari_er
leerier73111503leeri_er
lewder10479613lew__der
loader74316313lo__ader
loamier9349163loami_er
loftier1037763lofti_er
loggier93811143loggi_er
logier75015733lo_gi_er
loided83414023lo__ided
loiter64619173lo__iter
loonier73312683looni_er
loopier93711193loopi_er
loppier11369723loppi_er
lopsided1244253lopsided
lorded84916733lo_r_ded
lories64933043lo_ri_es
lorimers1036613lo_rimers
loriners839963lo_riners
lorises73918593lo_rises
lorries74518343lorri_es
louder74414603lo__uder
lousier72411623lousi_er
lower85830413low___er
lowlander1342993lowlander
lowlife1335143lowlife_
lowlifers1542953lowlifers
lowlifes1434333lowlifes
lowlives1434573lowlives
moorier93113073moori_er
nonwriter1246223nonwriter
order65019363_o_r_der
outrider92410563outrider
postrider1246643postrider
powder123611903pow__der
rewriter1137923rewriter
rider65231303___rider
rowdier11348593rowdi_er
solider82912453so_lider
sorrier72313733sorri_er
strider84315723_strider
topsider1144503topsider
towerier1137123toweri_er
voider103611553vo__ider
wider94826353__w_ider
wordier112511213wo_rdier
worrier102311683worri_er
wrier84521753__wri_er
writer94416513__writer

Search took 10 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.1701051123.5
2DLD Change Limit1461621039.23615825.2
3Display Results1031030.0303433.3
 (SQL Overall)1786911039.43618937.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.