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

131 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
titis5602381(None) 
mitis75425991mitis
otitis63612341otitis
tikis95615971tikis
tipis76019921tipis
titi47130621titi_
tits46145041tit_s
zitis145815581zitis
aits46355532ait_s
antis55033312antis
bidis86721142bidis
bites75641172bites
bits66148162bit_s
bitts75022592bitts
cites74435592cites
cities84524852cities
cutis77723762cutis
ditas65923672ditas
dites66339152dites
dits56450522dit_s
finis86824262finis
fits76043462fit_s
gites65630182gites
gits55744592git_s
hits75545132hit_s
ibis66519582_ibis
intis55121642intis
iris45732552_iris
iritis63113732iritis
its35538832_it_s
iwis77117012_iwis
kites95432542kites
kiths125814972kiths
kits86441762kit_s
kiwis12328582kiwis
litas54923772litas
lits46252492lit_s
metis75025902metis
midis85923412midis
minis75432992minis
mites75141802mites
mitts75523752mitts
nites55736342nites
nitid61817832nitid
nits45741642nit_s
otitic83112682otitic
pikis115116392pikis
pilis75825202pilis
pitas77427672pitas
piths105817542piths
pities83828082pities
pits66348742pit_s
rites54442552rites
rotis56327052rotis
satis55633672satis
sites56045432sites
sits45050202sit_s
situs55019232situs
tamis76728732tamis
tapis75028862tapis
tates55444982tates
tats46858132tat_s
taxis126821972taxis
testis64916712testis
teths85418512teths
tetris62816292tetris
tets45847452tet_s
this76027382t_his
tibia7312402tibia
tibias839952tibias
ticks115823292ticks
tics65729632ti_cs
tides64830152tides
tidies74721832tidies
tiers55526522tiers
ties45248312ti_es
tiffs114414882tiffs
tikes95628902tikes
tiki87620842tiki_
tiles55542102tiles
tills54631712tills
tils45739612ti_ls
tilths9459372tilths
tilts55325612tilts
times75630822times
timid84815732timid
tines54848422tines
tings65329202tings
tins45251302ti_ns
tints56030922tints
tipi69924432tipi_
tips66436762ti_ps
tires55437492tires
tirls54519802tirls
tiros54524892tiros
tis37056642__tis
tit36771052tit__
titan53318172titan
titans63414912titans
titbit839822titbit
titbits935802titbits
titer55430612titer
titers64526412titers
tithe85319702tithe
tithes94720212tithes
titian62512662titian
titians72710452titians
title54721072title
titles63719922titles
titlist7312922titlist
titre54619392titre
titres64718932titres
tittie63213152tittie
titties73617362titties
titty85316652titty
toits55327472toit_s
topis76025832topis
totes55139682totes
tots46654122tot_s
trois57226092trois
tuis44829642t_uis
tuts45838452tut_s
tuttis63611372tuttis
tutus55214812tutus
twits86015792twit_s
tzitzis1542412tzitzis
wites85536962wites
wits76044872wit_s
yetis85418392yetis
ziti136022372ziti_
zits136030292zit_s

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.1561145455.1
2DLD Change Limit538001311.44037361.1
3Display Results1311310.0304366.7
 (SQL Overall)1786911311.626109896.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.