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

94 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
lecturer1013603(None) 
lecture9149521lecture_
lectured11127231lectured
lecturers11124231lecturers
lectures101310161lectures
gesturer935982gesturer
letterer8259222letterer
securer958252sec_urer
venturer1137242venturer
capturer1246093capturer
censurer10228133censurer
curer75030753__c_urer
declarer1148063declarer
demurer1037873de_murer
denture8311893denture_
dentures9312453dentures
devourer1235063devourer
electret10412003elect_ret
endurer83210363_endurer
ensurer73011903_ensurer
enterer72015633_enterer
facture12108933facture_
factures13129033factures
feature1039853feature_
featured1237683featured
features11310333features
fetterer11207813fetterer
fracturer14134643fracturer
gesture839243gesture_
gestured1036993gestured
gesturers1044283gesturers
gestures9310013gestures
hectare1238463hectare_
hectares1338853hectares
hectored1436883hectored
labourer1045763labourer
lacquer18135153lacqu_er
lacquerer2043253lacquerer
leaguer835793leagu_er
leather103815783leat_her
lecher113415853lec__her
lechered1437523lechered
lectern937033lecter_n
lecterns1035943lecterns
lector83514993lect__or
lectors93415773lector_s
lecturing1237303lecturing
lefter93613433left__er
leftover1442713leftover
leisure736693leisure_
leisured934763leisured
leisures836683leisures
lemures938793le_mures
letter63722583le_t_ter
lettered92910783lettered
letterers9228113letterers
lettuce943323lettuce_
lettuces1043503lettuces
litterer82810173litterer
loiterer837083loiterer
lurer54625313l___urer
maturer938983_maturer
measurer1035953measurer
nurturer844473nurturer
pasturer1037523pasturer
perjurer17285903perjurer
perturber1343153perturber
pesterer102412713pesterer
pewterer13256313pewterer
picture1158613picture_
pictured1346573pictured
pictures1249343pictures
posturer1038923posturer
restorer84813723restorer
retirer74715013re_tirer
returner8397983re_turner
scourer93910433_scourer
sectored1138073sectored
secure8513533sec_ure_
secured1059723sec_ured
securers1057153sec_urers
secures9613163sec_ures
texture1497083texture_
textured1695483textured
textures1597523textures
torturer835493torturer
vectored1435633vectored
venture10311173venture_
ventured1238273ventured
venturers1245523venturers
ventures11311493ventures
vesture10310373vesture_
vestured1237463vestured
vestures11311043vestures

Search took 8 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.403443402.0
2DLD Change Limit146162946.58022213.1
3Display Results94940.0303133.3
 (SQL Overall)178691947.01325480.0
 
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.