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

97 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
skycap174291(None) 
skycaps1842701skycaps
skyman1535312skyman
skyway1933342skyway
becap114315053_becap
cap76758983___cap
cycad13507273_cycad
cycas126513823_cycas
gelcap1136213gelcap
glycan1234903glycan
hubcap1553993hubcap
icecap1245223icecap
knap105815403_k_nap
kyack13468263_kyack
kyak105213633_ky_ak
kyar116916843_ky_ar
kyat116025523_ky_at
madcap1336333madcap
mayhap1635233mayhap
midcap1336473midcap
mobcap1444113mobcap
mudcap1335133mudcap
recap95718023_recap
redcap1158493redcap
sap56463233s___ap
satrap86212553satrap
scab85926713s__cab
scad75725763s__cad
scag76626893s__cag
scalp95217983s__calp
scam85932353s__cam
scamp115717313s__camp
scan65530453s__can
scape96921843s__cape
scar66434203s__car
scarp95724103s__carp
scat65848373s__cat
scaup95515993s__caup
scop85925523s__cop
scrap97120403s_crap
scup84822383s__cup
siccan1037593siccan
ska76925863sk__a_
skag96321513sk__ag
skas85325713sk__as
skat87037893sk__at
skean94415623sk_ean
skelp114211423sk_elp
skep105219353sk__ep
skimp135411313sk_imp
skip105421743sk__ip
skoal93811453sk_oal
skua86113153sk_ua_
skuas95611733sk_uas
skullcap1641023skullcap
sky106420993sky___
skybox2242293skybox
skyed13529923sky_ed
skyey15537223sky_ey
skying14399983skying
skyjack2242763skyjack
skylark1343273skylark
skylit1338273skylit
skymen1535313skymen
skysail1462833skysail
skywalk1642353skywalk
skyward1843863skyward
skyways2043223skyways
slap66434043s__lap
snap65727033s__nap
sneap75514823s_neap
snowcap1442823snowcap
soap65831133s__oap
soca66330053s_oca_
socas74026183s_ocas
soucar839323soucar
sowcar1135863sowcar
soya75724433soy_a_
soyas84520913soy_as
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
strap77925263s_trap
stylar9358113stylar
styrax1675243styrax
succah1336643succah
sulcal8311273sulcal
swap95925433s__wap
syce95820283s_yc_e
sycee105018623s_ycee
syces106416463s_yces
syncarp1444533syncarp
syrup103010963s_yrup
sysop1037193s_ysop
toecap1037323toecap
uncap9312283_uncap
yap85949823__y_ap

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 Filter1786911127160.1231452772.4
2DLD Change Limit112716976.04618643.1
3Display Results97970.0166062.5
 (SQL Overall)178691976.18528891.0
 
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.