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

109 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
slippered143482(None) 
lippered13287951_lippered
skippered1843431skippered
chippered1945002chippered
kippered17255622_kippered
lappered13288212_lappered
lippened13255222_lippened
loppered13326752_loppered
scuppered1643932scuppered
simpered1338252s_impered
slipped124711742slipp__ed
slipper113712982slipper__
slipperier1442702slipperier
slippers123711232slipper_s
slippery15275862slipper_y
slithered13136622slithered
slivered12218102sli_vered
stoppered1444472stoppered
zippered22244822_zippered
blinkered1644413blinkered
blipped14377193blipp__ed
blistered12167683blistered
blithered15156123blithered
calipered1454873cali_pered
choppered1964883choppered
ciphered1637053_ciphered
clinkered1634773clinkered
clipped14439833clipp__ed
clipper133710323clipper__
clippers14368843clipper_s
coppered153410543_coppered
diapered1238003_diapered
flickered1943753flickered
flipped15358513flipp__ed
flipper14389143flipper__
flippers15338003flipper_s
flittered13196253flittered
glimmered1543103glimmered
glistered11176293glistered
glittered11195403glittered
kipperer16294723_kipperer
lappeted13255833_lappeted
limbered13158123_limbered
lingered10129643_lingered
lipped114419543_lipp__ed
lipper104219633_lipper__
lippers113416443_lipper_s
littered92511383_littered
livered113111633_li_vered
peppered1236123_peppered
scampered1635233scampered
scarpered1435113scarpered
sceptered1444723sceptered
shickered19115723shickered
shimmered1744783shimmered
shipped153312103shipp__ed
shipper143514043shipper__
shippers153012313shipper_s
shivered15177103shi_vered
silvered12237563s_ilvered
simmered1336863s_immered
simperer1237173s_imperer
sintered92213903s_intered
sipped113720633s_ipp__ed
sipper103920993s_ipper__
sippers113117753s_ipper_s
sistered92612803s_istered
skipped16358413skipp__ed
skipper15339573skipper__
skippers16318203skipper_s
skittered1434633skittered
slabbered14165083slabbered
slandered1137473slandered
slapped123511843slapp__ed
slapper113512463slapper__
slappers123710943slapper_s
slathered13148543slathered
slavered12188033sl_avered
slickened1644293slickened
slipcased1462623slipcased
slipcovered196923slipcovered
sliped95417063sli_p__ed
slipformed1861723slipformed
slippage13103943slippage_
slippages1483983slippages
slipperiest1552393slipperiest
slippier1256533slipp_ier
slipware1344543slipware_
slipwares1444243slipwares
sliverer11237633sli_verer
slobbered14144223slobbered
slopped123511443slopp__ed
slubbered14175253slubbered
slumbered14215593slumbered
snickered16115343snickered
sniggered1243443sniggered
snipped123510043snipp__ed
snipper113911333snipper__
snippers12299723snipper_s
speered103614813s__peered
sphered133512313s__phered
spiered104412463s__piered
splintered1383923splintered
stippled1345303stipp_led
supered10316123s__upered
swithered16135463swithered
syphered1755013s_yphered
whimpered20144023whimpered
whispered18144373whispered

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.1531167915.0
2DLD Change Limit1486411097.17320722.3
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.37224239.1
 
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.