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 “institutors” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
institutors115321(None) 
instituters1153221instituters
institutor1053671institutor_
instigators1245922instigators
instituter1044512instituter_
institutes1046052institut_es
institutions1244732institutions
antitumors1253743an_titumors
initiators10127313initi_ators
insinuators1154143ins_inuators
inspirators1345553inspirators
instigator1146413instigator_
institute946443institut__e
instituted1144943institut_ed
instituting1244803instituting
institution1145293institution
instructors1355383instructors
prostitutors1452913prostitutors
antitumor1143804an_titumor_
castigators1445544castigators
constitutes1376164constitut_es
constitutions1554864constitutions
destitutes1156524destitut_es
destitutions1385254destitutions
distributors1553034distributors
estimators1247024_estimators
estivators1345924_estivators
hesitators1385854hes_itators
imitators1147014i__mitators
indicators1348614in_dicators
indictors1247624in_di_ctors
inflictors1543954infli_ctors
inhibitors1544004in_hibitors
initiator998114initi_ator_
initiatory13125814initi_atory
inquisitors2052584inquisitors
inseminators1453764inseminators
insetters9187134ins_et_ters
insinuator1054234ins_inuator_
insisters997654ins_i_sters
inspectors1444934ins_pectors
inspirator1245774inspirator_
inspiratory1654414inspiratory
inspissators14111824inspissators
instigates1148424instigat_es
instigations1348244instigations
instillers1043664insti_llers
instincts1144534instinct__s
institutional1353504institutional
instructor1255164instructor_
insulators1047264ins_ulators
intimaters1297854in_timaters
intitules966774in_titu_les
investigators1752464investigators
invitatory1644784in_vitatory
irritators1045134i_rritators
masticators1546324masticators
mistutors1144764mis__tutors
prostitutor1353134prostitutor_
reinstitutes1253264reinstitut_es
restitutes1057834restitut_es
restitutions1275704restitutions
rusticators1344944rusticators
statutory1242414__statutory

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 Filter1786911488190.423422437.4
2DLD Change Limit148819648.75017007.9
3Display Results64640.0302133.3
 (SQL Overall)178691649.20319416.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.