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

180 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
topis7602583(None) 
tapis75028861tapis
tipis76019921tipis
topes76941761topes
tophs105220051tophs
topi67830391topi_
topic95721501topic
topics104714581topics
topos75726391topos
tops66248121top_s
aspis74618142aspis
atopic103514142atopic
atopies92816432atopies
bops86037982bop_s
copes97747102copes
copies104130302copies
cops86751372cop_s
dopas85019062dopas
dopes84935042dopes
fops96532682fop_s
gopik1257532gopik
hopes105835642hopes
hops97942632hop_s
impis96213832impis
kepis115313362kepis
kois85129392ko_is
kojis16468432kojis
kophs145010932kophs
kops107031292kop_s
lapis76223152lapis
lopes76437342lopes
lops66043352lop_s
loris55329152loris
louis57322322louis
mopes95134982mopes
mopish134311592mopish
mops85940132mop_s
noris54928272noris
obis66226832_obis
oops65232672oop_s
opes65942612_opes
ops56641252_op_s
opts68124742_opts
opus66420592_opus
pis56362032__pis
pois66539042po_is
polis74731162polis
popes95933812popes
popish133812112popish
pops86340952pop_s
ptosis83611822ptosis
qophs19507812qophs
ropes75940062ropes
rotis56327052rotis
sophs104916022sophs
sops65244562sop_s
stopes84525892stopes
stops74827282stop_s
tamis76728722tamis
tapas74627712tapas
tapes75838602tapes
tapir75917062tapir
tapirs84113172tapirs
taps66050672tap_s
taxis126821972taxis
tepas76521682tepas
tepid8314312tepid
this76027382t_his
tikis95615972tikis
tipi69924432tipi_
tips66436762tip_s
tis37056642t__is
titis56023812titis
toads65621062toads
tobies84521012tobies
todies74223552todies
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
toil46536282to_il
toils54527492toils
toit46353062to_it
toits55327472toits
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tones56048662tones
tongs65928462tongs
tonic74727652tonic
tonics83617862tonics
tonish93415902tonish
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
toots55331872toots
top510560682top__
topaz16315322topaz
tope65946382top_e
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
toph96326872top_h
tophe106718972tophe
tophes115218422tophes
tophi105215302tophi
tophus115210362tophus
toping94122992toping
topo66932402top_o
topoi76018352topoi
toras55540372toras
torcs75123762torcs
tores55352672tores
tori47542152tori_
toric76529312toric
torics85118352torics
tories65435882tories
torii55521592torii
toros54336192toros
torpid9310912torpid
torpids1037372torpids
torrs53923562torrs
tors46157382to_rs
torsi57423362torsi
torts56138122torts
torus54329762torus
toss45637972to_ss
totes55139682totes
tots46654122to_ts
tours55325862tours
touts54830392touts
towie85821872towie
towies93521192towies
towns86018882towns
tows78545552to_ws
toxic145315622toxic
toxics153910202toxics
toxin124716712toxin
toxins133314282toxins
toyish122911122toyish
toyos87519142toyos
toys78036342to_ys
trips74923362trips
trois57226092trois
tropes84824352tropes
tropic103014192tropic
tropics113610642tropics
tropin83316752tropin
tropins93116302tropins
tropism1139292tropism
tsoris63411192tsoris
tuis44829642t_uis
tupik1149002tupik
tupiks1235492tupiks
tups65628762tup_s
types105721062types
typic124511962typic
typist1139822typist
typos106015812typos
typps12549302typps
utopia8107882utopia
utopias9117722utopias
utopism1146332utopism
utopist938692utopist
wops96634152wop_s
yogis95617742yogis
yonis85020822yonis
zoris145320012zoris

Search took 3 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.0931921408.6
2DLD Change Limit538001801.92028020.8
3Display Results1801800.0463913.0
 (SQL Overall)1786911802.05986785.3
 
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.