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

107 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
ferrules113616(None) 
ferrule1035861ferrule_
ferruled1263921ferruled
ferules103112721fe_rules
ferrates113013412ferrates
ferreled1234832ferreled
ferrels10248622ferrel_s
ferries103521082ferr_ies
ferrites112312832ferrites
ferrums1265982ferru_ms
ferulas103110752fe_rulas
ferule93413202fe_rule_
feruled11318412fe_ruled
hercules1337632hercules
nervules1145012nervules
overrules12129092overrules
barbules1238043barbules
berries94423553berr_ies
berryless1442293berryless
cellules1036813cellules
cereuses1049243cereuses
ceruses93716233ce_ruses
derries83124623derr_ies
derrises93012783derrises
detrudes1036193detrudes
farles96025783f_ar_les
fearless1137873fear_less
features11310333features
febrile1237153febrile_
females12310663fe_males
fenagles12186083fenagles
ferals94216643fe_ral_s
feres86038183fe_r__es
ferities111416713ferities
ferlies103216693fe_rlies
fernless1136063fe_rnless
ferrate103014043ferrate_
ferrel92810203ferr__el
ferrelled1343923ferrelled
ferreous1146033ferreous
ferret93021173ferr__et
ferreted1236323ferreted
ferreter1136543ferreter
ferreters1246253ferreters
ferrets103111393ferr_ets
ferriages1345663ferriages
ferried113411523ferr_ied
ferrite103312753ferrite_
ferrous1049793ferr_ous
ferruling13134413ferruling
ferrum1147453ferru__m
ferrymen1643943ferrymen
fertile10311733fertile_
ferula93011173fe_rul_a
ferulae10309603fe_rulae
fescues1236783fescu_es
fetiales11319613fetiales
fettles103912733fe_ttles
fetuses10310243fe_tuses
formulas1346303formulas
fortunes1158283fortunes
freckles17126383freckles
freres94716173frer__es
furfures1445663furfures
gemmules13183213gemmules
herries104025073herr_ies
jerries143817513jerr_ies
kerries113317913kerr_ies
merles85322763me_r_les
misrules1039383misrules
nervule1044943nervule_
nervures1135123nervures
neurulas844833neurulas
opercules1345573opercules
overrule11149673overrule_
overruled13127813overruled
percales12313803percales
perdues103511333perdu_es
perdures11289683perdures
perfumes1555893perfumes
perfuses1358663perfuses
perjures17268083perjures
permutes1238713permutes
perries93226603perr_ies
perukes133210113pe_rukes
peruses94018163pe_ruses
petrales10312973petrales
pyrroles1345453pyrroles
reroutes8312223reroutes
rules55234253___rules
serrates82617013serrates
serries73925353serr_ies
sporules1037703sporules
subrules1039723subrules
terraces102712243terraces
terranes82514423terranes
terrases82111473terrases
terrenes82212593terrenes
terries73425613terr_ies
terrines82117533terrines
veinules1135913veinules
venules104011483ve_nules
verbiles1338923verbiles
verdures12247753verdures
verrucas1343923verrucas
virgules1244333virgules
xeruses143010753xe_ruses

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 Limit1461621077.72018932.9
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.92222556.3
 
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.