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

96 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
collaret10311670(None) 
cellaret103713571cellaret
collared113211141collared
collarets11327331collarets
cellared11398792cellared
cellarer10317922cellarer
cellarets11246062cellarets
claret84026572c__laret
collage102813752collage_
collaged12279962collaged
collagen11338562collagen
collages113514232collages
collar83816172collar__
collard103712922collar_d
collards113310192collards
collars93816572collar_s
collate92919682collate_
collated113615062collated
collates103019132collates
collet84030362coll__et
solleret8512222solleret
bollard103210503bollar_d
bollards11339153bollards
cabaret112519043c_abaret
callant94121223calla_nt
callet84536763call__et
caret75360563c___aret
cellae84915933cella_e_
cellar84514983cellar__
cellarers11236493cellarers
cellarette1252483cellarette
cellars93713693cellar_s
cigaret10412993c_igaret
clarets94111103c__larets
cleared103612463c_leared
clearer93710823c_learer
clearest1038653c_learest
coffret15310073co_ffret
coleader1139173coleader
collagens12256033collagens
collagist1248013collagist
collapse1244273collapse
collapsed1443223collapsed
collapses1344683collapses
collaring12310543collaring
collarless1243073collarless
collator10310373collator
collect113314593coll_ect
colleen939533coll_een
college102410433college_
colleger11227923colleger
colleges112410513colleges
colleted113011653colleted
collets93517903coll__ets
collide103214783collide_
collided12309793collided
collider113410413collider
collides113214463collides
collie83621993coll_ie_
collied103316673coll_ied
collier93618153coll_ier
colliers103613583colliers
colliery13307363colliery
collies94326583coll_ies
collude10337983collude_
colluded12296453colluded
colluder11276863colluder
colludes11279213colludes
collyria1344813collyria
colorant10414723colorant
colored10313473co_lored
colorer9312523co_lorer
coloured1148303coloured
colourer1037553colourer
colure8314153co_lure_
colures9315133co_lures
compare135814993compare_
compared153811823compared
comparer143611363comparer
compares143816433compares
compart134016003compar_t
coolant9316463coola_nt
coparent12412253co_parent
cullet84727313cull__et
dollar74110983dollar__
dollars83311023dollar_s
hollaed11359853holla_ed
hollered1237603hollered
pillared11228083pillared
pollard103511143pollar_d
pollarded1344703pollarded
pollards11299523pollards
soleret7321233so_leret
sollerets945253sollerets
tollage82610163tollage_
tollages92410193tollages

Search took 10 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.1701051123.5
2DLD Change Limit146162968.92316380.4
3Display Results96960.0462087.0
 (SQL Overall)178691969.13919552.6
 
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.