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

87 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
skycaps184270(None) 
skycap1742911skycap_
skyways2043222skyways
becaps123811403_becaps
caps87147893___caps
cycads14476213_cycads
cycas126513823_cyca_s
gelcaps1235203gelcaps
glycans1344233glycans
hubcaps1643543hubcaps
icecaps1343863icecaps
knaps115511173_k_naps
kyacks14416063_kyacks
kyaks11459163_ky_aks
kyars124813963_ky_ars
kyats125012443_ky_ats
madcaps1435243madcaps
mobcaps1543463mobcaps
mudcaps1444103mudcaps
recaps103615733_recaps
redcaps1247073redcaps
saps65346373s___aps
satraps95011643satraps
scabs94818643s__cabs
scads85419963s__cads
scags85520973s__cags
scalps104315233s__calps
scamps125014173s__camps
scams94423973s__cams
scans74625103s__cans
scape96921843s__cape
scapes105122263s__capes
scarps104718603s__carps
scars75433533s__cars
scats75930603s__cats
scaups105411933s__caups
schnaps1443703schnaps
scops95820193s__cops
scraps106017243s_craps
scups95316653s__cups
shnaps1148083s_hnaps
skags104316073sk__ags
skas85325713sk__a_s
skats94621543sk__ats
skeans104512913sk_eans
skelps12407923sk_elps
skeps115614253sk__eps
skimps14488043sk_imps
skips115616603sk__ips
skoals10438243sk_oals
skuas95611733sk_ua_s
skullcaps175933skullcaps
skyjack2242763skyjack
skyjacks2342543skyjacks
skylark1343273skylark
skylarks1442503skylarks
skyman1535313skyma_n
skyphos1963733skyphos
skysail1462843skysail
skysails1552493skysails
skywalk1642353skywalk
skywalks1742193skywalks
skyward1843863skyward
skywards1943373skywards
skyway1933343skywa_y
slaps76025713s__laps
snaps74719563s__naps
sneaps84510863s_neaps
snowcaps1542703snowcaps
soaps75120713s__oaps
socas74026183s_oca_s
soucars938423soucars
sowcars1236013sowcars
soyas84520913soy_a_s
spicas104715823spica_s
straps87721783s_traps
succahs1435323succahs
swaps104819203s__waps
sycees11409653s_ycees
syces106416463s_yc_es
synapse1234133s_ynapse
syncarps1543903syncarps
syrups11277953s_yrups
sysops1136013s_ysops
toecaps1135553toecaps
uncaps1039813_uncaps
yaps95933523__y_aps

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 Filter1786911340270.410435831.7
2DLD Change Limit134027876.67020094.0
3Display Results87870.0165437.5
 (SQL Overall)178691877.09625181.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.