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

214 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
tariffs133459(None) 
tariff12711361tariff_
griffs13398992_griffs
riffs115114612__riffs
tariffed1533722tariffed
thrifts1335522thrifts
tiffs114414882t__iffs
alifs86121263_ali_fs
arfs76029963_ar__fs
arias55438043_ari_as
ariels65119373_ariels
arils58732203_ari_ls
arises65233803_arises
atriums939063atriums
baffs134718053ba__ffs
bailiffs1642563bailiffs
barfs104826003bar__fs
barites94322343barites
bariums1139153bariums
biffs134814413__biffs
briefs115510073_briefs
caffs135417373ca__ffs
caitiffs1642883caitiffs
califs114915893cali_fs
carafes125015713carafes
caribes113715643caribes
carices114220953carices
caries85147623cari_es
carinas93622423carinas
carious93320283carious
caritas93316963caritas
cliffs14477593_cliffs
daffs125116423da__ffs
dandriffs1792313dandriffs
darics94314113dari_cs
darings93713653darings
diffs126315493__diffs
draffs13617903_draffs
drifts10499893_drifts
earings84517713earings
earmuffs1641373earmuffs
farinas103215253farinas
gaffs124914653ga__ffs
gliffs13436323_gliffs
goniffs14473903goniffs
griefs10418723_griefs
griff124416463_griff_
griffe13438093_griffe
griffes14367923_griffes
grifts104511683_grifts
gruffs13337453_gruffs
jarinas143712203jarinas
jiffs185710313__jiffs
kaifs125715653ka_i_fs
kalifs134410983kali_fs
lariats7615063lariats
laris54737463lari__s
layoffs1642573layoffs
marinas93519413marinas
marines93928043marines
mastiffs1644233mastiffs
midriffs1742533midriffs
miffs134512883__miffs
naffs116213963na__ffs
naifs87617423na_i_fs
naris55735293nari__s
pariahs123812343pariahs
parians93519743parians
paries84742523pari_es
parings104219223parings
paris75145943pari__s
parises94827193parises
payoffs1843243payoffs
quiffs21135433_quiffs
raffs115017523__raffs
rarifies11311943rarifies
rarify123210063rari_fy
riff104430113__riff_
rifs74929013__ri_fs
rifts85718643__rifts
ruffs114516743__ruffs
sarins63932623sari_ns
saris54544953sari__s
scruffs1554173scruffs
serifs94017053seri_fs
sharifs13279903shari_fs
sheriffs17253923sheriffs
shrifts1335963shrifts
shroffs1634363shroffs
skiffs16327013_skiffs
sniffs12378843_sniffs
spiffs14328473_spiffs
spliffs1533563spliffs
staffs12349753sta__ffs
stiffs12389963_stiffs
strifes104716583strifes
tacrines10310563tacrines
taffias13377413taffias
taffies133012693taffies
taffy145110823ta__ffy
tafias93111963tafi_as
tahinis1048013tahinis
taigas73712573ta_igas
tails55634193ta_i_ls
tains54936323ta_i_ns
taints64520533ta_ints
takeoffs1842323takeoffs
takings124512573takings
takins105117403taki_ns
talions7314113talions
talipes9611603talipes
tamis76728733tami__s
tamises92715973tamises
tanists7313663tanists
tapirs84113173tapi_rs
tapis75028863tapi__s
tapises92914013tapises
taramas9612713taramas
tardies84225863tardies
tares57456563tar__es
targes74524603tar_ges
targets84314223targets
tariffing1644113tariffing
taring73932283tari_ng
tarmacs1138333tarmacs
tarns56433953tar__ns
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar__os
tarots66422993tar_ots
tarpans92513533tarpans
tarpons92612213tarpons
tarps76527123tar__ps
tarres64723043tar_res
tarriers83411713tarriers
tarries73324263tarries
tars46763953tar___s
tarsals72512603tarsals
tarsias74013373tarsias
tarsiers8298533tarsiers
tarsus6310513tar_sus
tartans72615823tartans
tartars73313403tartars
tarts57242023tar__ts
tartufe1064673tartufe
tartufes1164153tartufes
tartuffe1461903tartuffe
tartuffes1551623tartuffes
tarzans16329923tarzans
taurines8310553taurines
taxies135817333taxi_es
taxis126821973taxi__s
taxites1449673taxites
teffs115111733t__effs
thrift12412043thri_ft
thrifty1634193thrifty
thrills10398783thrills
thrips11299013thri_ps
thrives134611713thrives
tiff104727733t__iff_
tipoffs1543033tipoffs
toffs116016723t__offs
torics85118353tori_cs
tories65435883tori_es
traiks104013713trai_ks
trails64622513trai_ls
trains64725343trai_ns
traits65121983trai_ts
triacs83913223t_riacs
triads74513533t_riads
trials64319883t_rials
tribes85119023t_ribes
trices84826333t_rices
tricks125319013t_ricks
triens65417543t_riens
triers64321523t_riers
tries55742813t_ri_es
trifid1039063t_rifid
trifle94012883t_rifle
trifles103814833t_rifles
trigos74214173t_rigos
trigs65423063t_ri_gs
trikes105419493t_rikes
trills64319853t_rills
trims75021473t_ri_ms
trines64132563t_rines
triols66117803t_riols
trios55528093t_ri_os
tripes85324873t_ripes
tripos84014923t_ripos
trips74923363t_ri_ps
truffe1276233t_ruffe
truffes1356773t_ruffes
tsarinas835273tsarinas
tsarisms1056653tsarisms
tsarists857303tsarists
tuffs115118263t__uffs
turfs84620443tur__fs
turions7311573turions
turnoffs1442833turnoffs
tzarinas1733973tzarinas
tzarisms1965213tzarisms
tzarists1755693tzarists
varias95019913vari_as
varices123313573varices
variers103712663variers
varies94330873vari_es
various103113103various
waffs146315473wa__ffs
waifs115719873wa_i_fs
whiffs1835083_whiffs
yaffs145311123ya__ffs
zarfs174713623zar__fs
zaribas1836043zaribas

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.470380193.6
2DLD Change Limit1340272147.15318737.2
3Display Results2142140.0802675.0
 (SQL Overall)1786912147.70323197.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.