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

279 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
titians7271045(None) 
titans63414911tit_ans
titian62512661titian_
pitmans11188742pitmans
simians959202simians
tertians839102tertians
tibias839952tibia_s
titan53318172tit_an_
titis56023812titi__s
titman82711002titman_
titrant7315192titrant
titrants838482titrants
tuitions838282tuitions
witans93412932wit_ans
actinians11167003actinians
actins86321103acti_ns
actions94218513actions
antiars7314623antiars
artisans888523artisans
atmans84413963_atmans
attains7310983attains
avians93711563_avians
banians9312033banians
biotins93114453bioti_ns
biriani945643biriani
birianis1056343birianis
biting95321823biti_ng
bitmaps1344253bitmaps
cations94524143cations
chitins122713793chiti_ns
cities84524853citi_es
citing94220183citi_ng
citizens1943983citizens
citrals91111673citrals
citrins92614363citrins
citrons92913223citrons
coitions10312853coitions
cotans81317923cot_ans
cutins83919983cuti_ns
detains83716093detains
dictions111812673dictions
dietitians1142953dietitians
dioxans1555313dioxans
distains9413603distains
ditas65923673dit_a_s
dittany1135653dittany
divans104612393di_vans
diwans105110373di_wans
durians839573durians
editions9310403editions
etesians845473etesians
ethicians1445283ethicians
fetials103711743fetials
ficins113513983fici_ns
fictions132410743fictions
finials103210153finials
firmans12238523firmans
fustians1146403fustians
gentians937563gentians
gitano738043git_ano
gitanos837173git_anos
hetmans12187593hetmans
hitman112710223hitman_
iliads7448673_iliads
inions64417003_inions
initials848103initials
ixias12488373_ixia_s
kalians11310183kalians
kations114013663kations
kinins104014583kini_ns
kitbags1443883kitbags
kiting114117093kiti_ng
kittens11347583kittens
latinas74416463latinas
ligans76817733li_gans
lignans8398853lignans
limans84816303li_mans
linins65922143lini_ns
lipins85016883lipi_ns
litany939053lit_any
litas54923773lit_a_s
lithias1038823lithia_s
litigant946873litigant
litigants1043763litigants
lotions74614763lotions
magians10310753magians
martians103111613martians
matins84527783mati_ns
medians103214213medians
minions93314623minions
minivans1345413minivans
minyans1237263minyans
mirins83918903miri_ns
mitis75425993miti__s
mitises9315543mitises
mittens9349883mittens
motions94215003motions
nations74720563nations
nitons64614903nit_ons
notions74014483notions
obtains939163obtains
octans81411143oct_ans
oilcans936813oilcans
opticians1345543opticians
options93810603options
otitides937293otitides
otitis63612343otiti__s
otitises839163otitises
outmans92413283outmans
parians93519733parians
patinas96318523patinas
patins87528783pati_ns
petitions11511083petitions
pians75126963__pians
pinions93413603pinions
pitas77427673pit_a_s
pitiers93812653pitiers
pities83828083piti_es
pitman102412123pitman_
pitons85319043pit_ons
pitsaws1234993pitsaws
pittas86014523pitta_s
potions93417423potions
ptisans9317363pti_sans
radians83013823radians
ratans63819373rat_ans
rations74123433rations
rattans73411953rattans
retains74522253retains
retinas74819353retinas
ricins83618703rici_ns
rituals738353rituals
rutins63818393ruti_ns
satins64930483sati_ns
seitans73312303seit_ans
silvans10308333silvans
simian8811163simian_
sitars65417593sit_ars
sithens1039383sithens
siting74126623siti_ng
stains64923653_stains
statins73719773stati_ns
stations82415223stations
stictions1148353stictions
stotins73213873stoti_ns
tactions102912423tactions
tafias93111963tafia_s
tailfans1144553tailfans
tains54936323t_ai_ns
taipans9269553taipans
takins105117403taki_ns
talions7314113talions
tampans113310983tampans
tans46154823__t_ans
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
tatars64619793tat_ars
tenias64720073tenia_s
teopans939203teopans
tertials8510073tertials
tertian7511193tertian_
tetanus737933tet_anus
tetany959843tet_any
tetrads82910193tetrads
tetras63017623tetra_s
theins95015423thei_ns
therians1138313therians
thins85826333t_hi_ns
tiaras6314553tiara_s
tibia7312403tibia__
tibiae838483tibia_e
tibial849843tibia_l
ticals83214713ti_cals
tictacs1145793tictacs
tidiers8389773tidiers
tidies74721833tidi_es
tiding83520093tidi_ng
tidings93810263tidings
tieing73518763tiei_ng
tiepins939463tiepins
tiffany1642663tiffany
tiffins13327983tiffins
tiglons837343tiglons
tigons74112263ti_gons
tikis95615973tiki__s
tikkas934523tikka_s
tilaks1097353ti_laks
tiling73426553tili_ng
tilings84212793tilings
tilting83417103tilti_ng
timbals11239533timbals
timing93619303timi_ng
timings10279303timings
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
tincals93610643tincals
tineas64616483tinea_s
tining74927543tini_ng
tinman82411143tinman_
tins45251303__ti_ns
tinting84620603tinti_ng
tintings9288713tintings
tipcats1137103tipcats
tipis76019923tipi__s
tiring74023093tiri_ng
tisane6311573ti_sane
tisanes7311853ti_sanes
titaness836723tit_aness
titania738293tit_ania
titanias847103tit_anias
titanic968553tit_anic
titanism1048213tit_anism
titanous846553tit_anous
titbits935803titbits
titers64526413tit_ers
titfers10318933titfers
tithers104216733tithers
tithes94720213tit_hes
tithing113513893tithing
tithings12327693tithings
titi47130623titi___
titivate1146803titivate
titivates1246433titivates
titlark1144723titlark
titlarks1243693titlarks
titles63719923tit_les
titling83715793titling
titlists837293titlists
titmen8239883titmen_
titrate72215573titrate
titrates82314663titrates
titres64718933tit_res
tits46145043tit___s
titters74219623titters
titties73617363titties
tittles73413253tittles
tittups933353tittups
titubant1044613titubant
titulars845863titulars
toiting83217093toiti_ng
tolans64319273t_olans
tomans85419133t_omans
totals63115163tot_als
toting74123793toti_ng
toucans937583toucans
toxins133314283toxi_ns
trains64725343trai_ns
trans54933043__trans
trapans92812463trapans
trepans92311593trepans
triacs83913223t_riacs
triads74513533t_riads
trials64319883t_rials
triens65417543t_riens
triptans1047363triptans
tritiums1056393tritiums
tritons73814883trit_ons
tuition738823tuition_
turbans939563turbans
turions7311573turions
twains95811183twai_ns
twins85118983t_wi_ns
tympans14236813tympans
utopians1094903utopians
vigias104110893vigia_s
virions1039873virions
visions10311023visions
vitals94514303vit_als
vitiate103412953vitiate
vitiates112311433vitiates
vitrains1138283vitrains
wiccans1434603wiccans
wigans104511703wi_gans
witan83816503wit_an_
withins133511693withins
witing103522823witi_ng
zitis145815583ziti__s

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.406440125.6
2DLD Change Limit1340272797.15618729.3
3Display Results2792790.0933000.0
 (SQL Overall)1786912797.65523343.0
 
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.