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

57 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
trisceles114529(None) 
triscele1045431triscele_
triskeles1344271triskeles
trickles143013762tri_ckles
trisemes1036642tris_emes
triskele1244572triskele_
brickles162810283bri_ckles
bricoles122610303bri_coles
bristles101510433bris_tles
frisbees13295013frisbe_es
frisees104411693fris_e_es
gristles9189203gris_tles
isosceles1143303isosceles
priceless1336883pri_celess
prickles162511093pri_ckles
princelet1346533princelet
princelets1443463princelets
priseres10310823pris_eres
rescales103414573_rescales
risibles1035783_risibles
rissoles839113_rissoles
strickles1567813stri_ckles
thistles1198233this_tles
tickles133416853t_i_ckles
traceless11228643tr_aceless
trachles13311753tr_achles
trauchles1445493trauchles
treacles1039703treac_les
tressels8367653tressel_s
trestles83012553tres_tles
triangles1035743triangles
triazoles1844393triazoles
triceps11267343tri_ce_ps
tricepses1354643tri_cepses
trices84826333tri_c__es
trickle133613443tri_ckle_
trickled152610433tri_ckled
tricycles1644363tricycles
trienes74118413tri__enes
trifles103814823tri__fles
trindles93211683tri_ndles
triples94616873tri__ples
triplexes1844243triplexes
triremes1035523tri_remes
trisected1244913trisected
trisects1035983tris_ects
triseme936543tris_eme_
triskelia1352193triskelia
trismuses1143633trismuses
trisomes1039833tris_omes
trisomies1147163trisomies
tristezas1842743tristezas
triticales1246263triticales
truceless11235393tr_uceless
truckles14319383tr_uckles
trustees8339323truste_es
utricles1037223utri_c_les

Search took 9 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641577.87618872.7
3Display Results57570.0301900.0
 (SQL Overall)178691578.06222164.6
 
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.