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

92 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
subitems124549(None) 
subitem1138541subitem_
subatoms1245862subatoms
subideas1146442subideas
subsites10312762subsite_s
suiters73618872su_iters
suites63727402su_ite_s
albites9313203albite_s
arbiters1038853arbiters
auditees946463auditees
augites8312183augite_s
biters83925233__biters
bites75641173__bite_s
cubisms13306883cubi_sms
cubits103714023cubit__s
cubitus11346783cubit_us
curites93919863curite_s
dunites8313593dunite_s
gunites8313123gunite_s
items7499613___items
jubilees17244423jubilees
jubiles16289373jubile_s
lucites9311863lucite_s
orbiters1036593orbiters
qubits173710343qubit__s
qubytes2134383qubyte_s
rubies84420333rubi_e_s
sabines94318483sabine_s
samites93118713samite_s
sites56045433s__ite_s
skites104418033s_kite_s
smiters93414363s_miters
smites83921923s_mite_s
somites94219113somite_s
sopites93817173sopite_s
sorites73825243sorite_s
soubises10107993soubise_s
spirems11499563s_pirems
spites84127333s_pite_s
sprites94220333sprite_s
stems75219953s___tems
subareas1038623subareas
subatom1147043subatom_
subcutes1238573subcute_s
subdebs1236483sub_debs
subduers1186353subduers
subdues1099883subdue_s
subers85722643sub__ers
subfiles131710713subfile_s
subfixes20207493subfixe_s
subgums1235893sub_gums
subidea1037533subide_a
subito8410443subit__o
sublates10315003sublate_s
sublets92616703sub_lets
sublimers1345773sublimers
sublimes12310023sublime_s
sublines10315783subline_s
submits1139743submit__s
submitters1444433submitters
subnets92512083sub_nets
subsets92813103sub_sets
subsiders1246043subsiders
subsides11410823subside_s
subsisters1245013subsisters
subsite9412863subsite__
subsumes1246923subsumes
subsystems1751833subsystems
subteen938523sub_teen
subteens1037423subteens
subtend1037103sub_tend
subtends1136173sub_tends
subtest9513963sub_test
subtests1037533sub_tests
subtext1647653sub_text
subtexts1744903sub_texts
subtheme1544333subtheme
subthemes1644113subthemes
subtitles1156823subtitles
subwriters1544413subwriters
suite54829563su_ite__
suited74019423su_ite_d
suiter64121813su_ite_r
suitors73012473su_itors
suits55028053su_it__s
sulfites1139903sulfite_s
sumpters1238023sumpters
supines94216383supine_s
suttees74114063su_ttees
systems1234673s_ystems
uniters73814173_uniters
unites65024853_unite_s

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.1561145455.1
2DLD Change Limit146162927.81318707.5
3Display Results92920.0462000.0
 (SQL Overall)178691928.01522294.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.