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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 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
tulle5401993(None) 
tuille63012641tuille
tule45735871tu_le
tulles63218891tulles
belle75827832belle
boulle84614612boulle
bugle84721942bugle
bulge86419872bulge
bull65634872bull_
bulla74620562bulla
bullae83416162bullae
bulled94626492bulled
bullet84528612bullet
bulls75629572bulls
bully105124812bully
butle75023102butle
cull65929642cull_
culled94022472culled
culler84322252culler
cullet84727312cullet
culls75425812culls
cully105520462cully
dull56430442dull_
dulled84719422dulled
duller74017702duller
dulls64523742dulls
dully94921632dully
dulse65415042dulse
duple85315862duple
fille84327402fille
fugle94915542fugle
full75229152full_
fulled103820652fulled
fuller94220382fuller
fulls84623522fulls
fully114820862fully
guile64521132guile
gull54828452gull_
gulled84521372gulled
gullet74924832gullet
gulley104213162gulley
gulls65222982gulls
gully94020682gully
hull75428782hull_
hulled103920012hulled
huller93919102huller
hullo84417452hullo
hulls84923562hulls
lull44225762lull_
lulled74516442lulled
luller63415482luller
lulls54119652lulls
mille75029132mille
mule65236972mu_le
mull65128802mull_
mulla74317112mulla
mulled94721552mulled
mullen83714762mullen
muller83820352muller
mullet84126822mullet
mulley114013452mulley
mulls75124152mulls
null45125312null_
nulled74318272nulled
nulls55019982nulls
pule65040952pu_le
pull64731662pull_
pulled94322192pulled
puller83820812puller
pullet84026332pullet
pulley113713402pulley
pulls74425052pulls
pulse74219972pulse
quale143617852quale
rille55728732rille
ruble74521252ruble
rule49938422ru_le
selle54428312selle
stull54916272stull_
stulls63912982stulls
sullen62914292sullen
sully84622902sully
table75429602table
taille63116922taille
tale46154162t_ale
tall47240212tall_
taller63721962taller
talls55133432talls
tally84526862tally
telae54323292telae
tele45040872t_ele
tell44934702tell_
teller63519812teller
tells55828942tells
telly84920822telly
thole85620842thole
tilde65017342tilde
tile45451442t_ile
till45941202till_
tilled74722952tilled
tiller64222542tiller
tills54631712tills
title54721072title
toile54626492toile
tole46052902t_ole
toll45535262toll_
tolled73819032tolled
toller63819442toller
tolls54728432tolls
tousle64514652tousle
touzle15429002touzle
trull54012672trull_
trulls64110282trulls
tubae74716642tubae
tube65828662tu_be
tubule839852tubule
tuilles72411922tuilles
tules54532792tules
tulip71111692tulip
tumble103215642tumble
tune45635862tu_ne
tuque14469192tuque
turtle63213572turtle
tussle637142tussle
tutee5423522tutee
utile54718932utile
yule75725142yu_le

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 Limit538001271.54634799.5
3Display Results1271270.0304233.3
 (SQL Overall)1786911271.87295454.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.