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

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

86 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
strut5603073(None) 
stout57434051stout
strum75619451strum
strunt64918911strunt
struts65616801struts
sturt56028961sturt
brut66537962_brut
estrum81810512estrum
estrus61912112estrus
rut35560522__rut
scout75031452scout
scrub94914202scrub
scrum95418202scrum
scut65835542s_cut
serum75223472serum
setout64719462setout
shout85433172shout
shrub104814892shrub
shrug94512512shrug
shut76137592s_hut
sirup74014912sirup
slut45040592s_lut
smut66629782s_mut
snout54530632snout
sort46264812sor_t
sorus54527582sorus
spout75029632spout
sprat76635972sprat
sprit76736402sprit
sprout8419402sprout
sprue74717632sprue
sprug85313892sprug
spurt77227982spurt
start55642312start
stat47352692st_at
stent55634512stent
stet45947322st_et
stilt54831982stilt
stint57037662stint
stoat57135952stoat
stopt76528352stopt
stot46347332st_ot
stott56929792stott
stoup75517072stoup
stour54916742stour
stouts65019002stouts
strait64025892strait
strap77925262strap
strata63616282strata
strath93216372strath
strati63518902strati
straw813321292straw
stray88525572stray
street64125772street
strep77120852strep
strew89220662strew
stria55723212stria
strict84821042strict
strip77524342strip
stript85222192stript
strop77422242strop
stroud7310382stroud
strow88920572strow
stroy87720392stroy
struck12489262struck
struma84313272struma
strums84716452strums
strung75213022strung
strunts7429542strunts
stub66221842st_ub
stud56220092st_ud
stum65526022st_um
stun45623452st_un
stunt55328172stunt
sturts63915142sturts
syrup103010962syrup
taut47048962_taut
tout46753822_tout
tret46653532_tret
trot46351312_trot
trout57332572_trout
true46725852_true
trug55720042_trug
trust55426852_trust
truth85214152_truth
tut36758092_t_ut

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800861.39038705.0
3Display Results86860.0165375.0
 (SQL Overall)178691861.702104988.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.