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

90 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
scalenus104554(None) 
calends1039522_calends
scalene9310772scalen_e
scaleni936882scalen_i
scalers93817262scale_rs
scales84529312scale__s
scaleup1134482scale_up
scaleups1243392scaleups
silenus7369692s_ilenus
acalephs1542993acalephs
aculeus937513acule_us
calamus1139243_calamus
calesas9411833_calesas
callous93516603_callous
callus85317073_cal_lus
caseous9312513_caseous
catenas9313113_catenas
clonus85212413_c_lonus
coleus86818273_cole_us
colonus94413443_colonus
esculents1144693esculents
galenas83310343_galenas
kalends1235683_kalends
saleps85014903s_ale_ps
sales56055593s_ale__s
salients839563s_alients
salinas73116093s_alinas
salines74029413s_alines
salons63823693s_alon_s
scabious1246593scabious
scablands1443783scablands
scabrous1245993scabrous
scalades11258803scalades
scalados11276083scalados
scalages113010253scalages
scalares103210983scalares
scalars93711903scal_ars
scalds94813693scal__ds
scale74629143scale___
scaled94822443scale__d
scaleless1135513scaleless
scalepan1244513scalepan
scalepans1343823scalepans
scaler84321603scale__r
scaliness1149303scaliness
scaling103519373scalin_g
scallops12297393scallops
scalls84218203scal__ls
scalpels12345883scalpels
scalpers123710863scalpers
scalps104315233scal__ps
scanners10379703scanners
scans74625103sca__n_s
scants85219723sca__nts
scapes105122263scape__s
scarers94618503scare_rs
scares85033003scare__s
scarious10610203scarious
scarless10189053scarle_ss
scarlets10178573scarle_ts
scavenge1442813scavenge
scavenges1542903scavenges
scenas84114703sc__enas
scends95213003sc__ends
scenes84520353sc__enes
scents85317023sc__ents
schlepps1762563schlepps
schleps1445483schle_ps
scleras948223sc_leras
sclerous1047913sc_lerous
scoleces1237073scoleces
screens95212173screen_s
sealants82610743sealants
sealers74323553seale_rs
selenous848973s_elenous
shales94731253shale__s
silents73514493s_ilents
sklents11348163s_klents
soleus64615613s_ole_us
spales84728103spale__s
splenius1046033s_plenius
splents93912133s_plents
squalenes1845763squalenes
staleness9310783staleness
stales65538293stale__s
stamens93411483stamen_s
subgenus1145753subgenus
submenus1245903submenus
swales93920763swale__s
talents7312013_talents

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162907.23320207.7
3Display Results90900.0461956.5
 (SQL Overall)178691907.43524033.8
 
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.