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

65 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
theorists124660(None) 
theorises1247811theorises
theorist1149551theorist_
tenorists948192tenorists
theists1039152the__ists
theories11311592theori_es
theorise1137872theoris_e
theorised1344922theorised
theorizes2147072theorizes
theurgists1442252theurgists
amorists10411333_amorists
aorists74215833__aorists
aphorists1448263aphorists
arborists1147453arborists
atheists1138713athe__ists
chemists152710323che_mists
colorists112313593colorists
florists1138813_florists
hedonists1346053_hedonists
heists96814633_he__ists
heriots10312063_he_riots
heroisms1338693_heroisms
hoists95516023_h_o_ists
holists104413963_h_olists
hornists11208833_h_ornists
horsts95817513_h_or_sts
humorists1445783humorists
metrists1039853_metrists
motorists1149913motorists
querists1736543que_rists
rigorists1045673rigorists
sherrises12156863sherrises
tenebrists1243593tenebrists
tennists8297793t_ennists
tenorist8413023tenorist_
territs72714503t_erri_ts
terrorists1085613terrorists
theisms1237763the__isms
theist9314763the__ist_
theocrats1464683theocrats
theorbos1343643theor_bos
theorems1344693theor_ems
theorising1445183theorising
theorize2047073theori_ze
theorized2245803theorized
theorizer2144863theorizer
theorizers2243333theorizers
therapists1544403therapists
theriacs1336543the_riacs
therians1138313the_rians
thermits1338513the_rmits
theurgist1343163theurgist_
thirsts1036243th_ir_sts
thorias102312053th_ori_as
thorite10313443th_ori_te
thorites11312393th_orites
thoriums13166403th_oriums
threnodists1551943threnodists
thrifts1335523th__rifts
thrusts10226523th__rusts
tourists838313t_ourists
tsarists857303t_sarists
tzarists1755693t_zarists
verists103613673_ve_rists
zitherists2244413zithe_rists

Search took 7 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.420425454.8
2DLD Change Limit148641656.50022867.8
3Display Results65650.0331969.7
 (SQL Overall)178691656.95325699.8
 
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.