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

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

228 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
tripods1035905(None) 
tripod9399851tripod_
tripody13395981tripody
tripos84014921tripo_s
bipods11408592_bipods
triads74513522tri_ads
tricots9311562tricots
trigons84312092trigons
trigos74214172trigo_s
triode75311892tri_ode
triodes84012502tri_odes
triols66117802tri_ols
trios55528092tri_o_s
tripes85324872trip_es
triples94616872triples
triploids1245882triploids
tripodal1145142tripodal
tripodic1345332tripodic
tripodies1246572tripodies
tripoli937132tripoli
tripolis1038712tripolis
triposes1039972triposes
trips74923362trip__s
tritons73814882tritons
unipods1095702unipods
uropods1035872uropods
adipous1037183adipous
alipeds10386793alipeds
apods86316343__apods
bipeds11458053_bipeds
bipod104410823_bipod_
briards10398553briards
brios74725723bri_o_s
broods95416383br_oods
crepons1139313crepons
cricoids1347183cricoids
crinoids1147353crinoids
cripes105120873crip_es
dipody1336363_dipody
drips85417233drip__s
friends11396743friends
frivols1334743frivols
gipons9389603_gipons
grids75321393gri__ds
grinds84511843gri_nds
griots74713643gri_ots
griped104114713griped_
gripers104011463gripers
gripes94619873grip_es
grippes124810373grippes
grips85520133grip__s
grisons838993grisons
irids66417773iri__ds
isopods1045573isopods
lipids94310923_lipids
lipoids1038233_lipoids
myriapods1751533myriapods
myriopods1751823myriopods
orisons7310563orisons
periods10312243peri_ods
pods76540153___pods
primos104514423primo_s
prions84317783pri_ons
priors83914483pri_ors
prisons9313223prisons
prods85523553pr__ods
pteropods1444653pteropods
rapids94913893_rapids
repos74725793_repo_s
repots85621003_repots
resods74116303_resods
rids56539543_ri__ds
rigors72813713_rigors
rimous8311913_rimous
rinds64826143_ri_nds
riots54922013_ri_ots
ripcords1344073_ripcords
riped85226433_riped_
ripens85012173_ripens
ripes75435773_rip_es
ripoff1436433_ripoff
ripoffs1543383_ripoffs
ripost83615003_ripost
riposts9279403_riposts
rips66237433_rip__s
rods56442063_r__ods
roods65125283_r_oods
stridors9367293stridors
striped105214363striped_
stripers103911583stripers
stripes95320573strip_es
strips85719653strip__s
tailors73212383tailors
taipans9269553taipans
talipeds1183553talipeds
talipots1045613talipots
tampons112711553tampons
tarpons92612203tarpons
teapots939053teapots
teapoys1235963teapoys
teiids736693tei_ids
teinds738263tei_nds
tempos103812293tempo_s
tepoys1137543t_epoys
tetrapods1244723tetrapods
theropods1544953theropods
thiols95112763thi_ols
thirds10438603thi_rds
thrips11299013thrip__s
tigons74112253t_igons
tipis76019923t_ip_is
tipoff1436383t_ipoff
tipoffs1543033t_ipoffs
tips66436763t_ip__s
tiptoes939173t_iptoes
tiptops1136073t_iptops
tiros54524893t_iro_s
tods56141843t___ods
tomcods1234873tomcods
topos75726393t_opo_s
torpids1037373torpids
torpors939373torpors
traipses1036873traipses
traitors8310773traitors
trapans92812463trapans
trapes85024463trap_es
trappous1246013trappous
traps75727483trap__s
travois1037873travois
treads74817913tr_eads
tremors93711213tremors
trends75513543tr_ends
trepans92311593trepans
trepid9310083trepid_
triacids1146713triacids
triacs83913223tri_acs
triad65217723tri_ad_
triages82613793triages
trials64319883tri_als
tribade1037283tribade
tribades1136883tribades
tribals9610743tribals
tribes85119023tri_bes
triced95518673triced_
triceps11267343triceps
trices84826333tri_ces
tricks125319013tri_cks
triclads1146223triclads
tricorn937963tricorn
tricorns1036673tricorns
tricot8317753trico_t
tried65026913tri_ed_
trienes74118413trienes
triens65417543tri_ens
triers64321523tri_ers
tries55742813tri__es
trifid1039063trifid_
trifles103814823trifles
trifold1136243trifold
triform1237843triform
trigo65716053trigo__
trigon74513103trigo_n
trigs65423063tri__gs
trijets14308263trijets
trikes105419493tri_kes
trills64319853tri_lls
trilogy1136013trilogy
trimers94615143trimers
trims75021473tri__ms
trined74920713trined_
trines64132563tri_nes
trinodal945433trinodal
trio45233343tri_o__
triol55521363tri_o_l
triose64715383tri_ose
trioses75015653trioses
trioxids1644443trioxids
trip66830393trip___
tripack1565673tripack
tripacks1664893tripacks
tripart9311433tripart
tripe75425383trip__e
tripedal1144673tripedal
triphase1346193triphase
triple84215923trip_le
tripled104113833tripled
triplet94319213triplet
triplets103510263triplets
triplex16447803triplex
triploid1147353triploid
triploidy1543683triploidy
triply114211023trip_ly
tripped123911693tripped
tripper113711923tripper
trippers123210153trippers
trippet113714113trippet
trippets12357423trippets
trippy13457803trip_py
triptan947543triptan
triptans1047363triptans
trismus935563trismus
trisome9310223trisome
trisomes1039833trisomes
trisomy1235943trisomy
tritoma948043tritoma
tritomas1048023tritomas
triton63914893trito_n
tritone73613883tritone
tritones83413443tritones
triunes74311383triunes
trivets103911583trivets
trod57627953tr__od_
trode65322853tr__ode
trogons83410713trogons
trogs67022603tr__ogs
trois57226093tr__ois
troops85712773tr_oops
tropes84824353trop_es
tropics113610653tropics
tropins93116303tropins
trots56629943tr__ots
trows88826183tr__ows
troys86418613tr__oys
turions7311573turi_ons
typos106015813t_ypo_s
unipod946853unipod_
urinous7310083urinous
uropod937263uropod_

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272287.34318252.3
3Display Results2282280.0802850.0
 (SQL Overall)1786912287.57923577.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.