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

69 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
hellcats134632(None) 
hellcat12410171hellcat_
hepcats1436472he_pcats
bearcats1267023bearcats
bullbats1255893bullbats
cellars93713693cell_ars
cellists1038563cellists
cellmate1237873cellmate
cellmates1347513cellmates
delicate11315493delicate
delicates12314313delicates
delicts104012253delic_ts
eclats8313033_ecl_ats
elects83315003_elec_ts
elicits9311233_elicits
fellahs13428393fell_ahs
fellas95116963fell_a_s
fellate10313433fell_ate
fellates11312753fell_ates
gelcaps1235203ge_lcaps
gellants9308283gellants
hallahs133912463hall_ahs
halloas104318463halloa_s
hallways1745423hallways
heats85838403he___ats
heeltaps1343073heeltaps
heliast10312073he_liast
heliasts1136103heliasts
helical12311153helica_l
helices12313723helic_es
helicity1648503helicity
helicons1337613helicons
helicopts1643803helicopts
helilifts1542373helilifts
helipads1443873helipads
helleris113010183helleris
hellers103619833hell_ers
hellions11310023hellions
hellkite1544933hellkite
hellkites1644633hellkites
helloes103717463hell_oes
hellos95321683hell__os
hells85032043hell___s
helmets12309073he_lmets
helots95217703he_l_ots
helpmate1545603helpmate
helpmates1645513helpmates
hepcat13611823he_pcat_
hilloas104413553hilloa_s
hollas94616903holl_a_s
holloas103814943holloa_s
hulloas103911913hulloa_s
pelicans1238093pelicans
pellets94014783pell_ets
polecats1248833polecats
refloats1156913refloats
relicts94414593relic_ts
relocate10713533relocate
relocates11712933relocates
relucts9369673reluc_ts
selects91912143selec_ts
sellouts837493sellouts
shellacks1844553shellacks
shellacs1345573shell_acs
telecast1048303telecast
telecasts1145543telecasts
vellicate1446433vellicate
vellicates1545903vellicates
wildcats1444173wildcats

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 Filter1786911461620.420425454.8
2DLD Change Limit146162698.09318060.3
3Display Results69690.0332090.9
 (SQL Overall)178691698.54620909.3
 
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.