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

207 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
wartime123774(None) 
wartimes1336961wartimes
airtime948062airtime
daytime1344782daytime
maritime1247382maritime
partite9317132partite
pastime114611972pastime
ragtime1036162ragtime
warlike142410472warlike
wartier103413912wartier
wartlike1537042wartlike
active11313743_active
airtimes1037503airtimes
anime75423203_a_nime
anytime1246043anytime
arame75026623_ar_ame
arise56436433_ar_ise
arrive91311793_arrive
arsine64021043_arsine
article9310923_article
artier63419733_artier
artily92814713_artily
artist64125543_artist
artiste73813693_artiste
attire62412383_attire
baptise1139553baptise
baptize2036973baptize
barbie105018353barbi_e
barite84224813bar_ite
barmie103816393barmi_e
bastile9313913bastile
bawtie113812143bawti_e
bedtime1236973bedtime
berime105317333ber_ime
betime105914833_betime
bigtime1235753bigtime
captive1438973captive
carbide126112493carbide
carbine112918643carbine
cardiae10713703cardiae
caribe103416753car_ibe
carline93923613carline
carmine112918483carmine
carnie84421093carni_e
cartage10312593cartage
carte75940423cart__e
carting104228283carting
cattie85221013catti_e
centime114513033centime
crime94822693_cr_ime
darkie113714013darki_e
darting94020663darting
dartle73714833dart_le
dative10311813da_tive
dautie72914693dauti_e
dawtie103011093dawti_e
daytimes1434483daytimes
earthmen1346393earthmen
farcie114816473farci_e
farside1138603farside
farting114120753farting
fertile10311733fertile
foretime1348213foretime
furtive1337173furtive
garpike1435093garpike
gratine84719193gratine
grime85021323_gr_ime
halftime1643313halftime
harmine122816193harmine
intime81014273_intime
karting123716063karting
larine63927043lar_ine
latrine7715123latrine
lattice938433lattice
maremme1054603maremme
marine84230403mar_ine
marline93320953marline
marlite92917073marlite
marmite112413993marmite
martial92415413martial
martian93514683martian
martin84122523marti_n
martinet10319643martinet
marting103325013marting
martini93613873martini
martins93322063martins
mealtime1245123mealtime
meantime1245983meantime
mistime11312613mistime
mortice11711493mortice
mortise9713533mortise
nardine82712573nardine
nargile847653nargile
narine63422553nar_ine
native9613013na_tive
oarlike113411193oarlike
onetime937623onetime
optime1079343_optime
overtime131312273overtime
pantie84326473panti_e
pantile93918483pantile
pardie96021443pardi_e
pardine103616723pardine
partake1339643partake
partial92616263partial
partible1238063partible
particle1239533particle
partied103516553partied
partier93520713partier
parties93230863parties
parting103527383parting
partita9310863partita
parvise124211693parvise
pastie85525523pasti_e
pastimes123611903pastimes
patine85328123pa_tine
pattie84020963patti_e
playtime1544793playtime
prime96525603_pr_ime
quartile1747043quartile
ragtimes1135823ragtimes
ratine65131823ra_tine
ratite65022423ra_tite
retime85321803_retime
rime65138883__r_ime
saltie63422423salti_e
saltine75018563saltine
saltire73113033saltire
santimi938783santimi
santims9312593santims
santimu938553santimu
sardine83317393sardine
satire63218003sa_tire
septime1138783septime
smartie9310163smarti_e
sortie63621983sorti_e
stime76521793__stime
tactile9310613tactile
tardive1136893tardive
tartare73012683tartare
tartier74123263tartier
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
tartufe1064673tartufe
tattie64817513tatti_e
teatime9310083teatime
termtime1244773termtime
time66235013___time
tortile7313193tortile
uptime1067663_uptime
waddie114013323waddi_e
waffie15338563waffi_e
waftage14115323waftage
wafting143911663wafting
wafture1334853wafture
wagsome1345213wagsome
wahine123813013wa_hine
waiting113618953waiting
waive114214603wa__ive
wakame1535433wa_kame
wallie93216803walli_e
wame95035483wa___me
wantage11119623wantage
wanting114220173wanting
warble113516603war_ble
warding123918143warding
ware76254723war___e
warfare1336733warfare
warier93722893war_ier
warily122915093war_ily
waring105029443war_ing
warking153519573warking
warm95935673war__m_
warmed124516893war__med
warmer113816733war__mer
warming133515083warming
warmish1538373warmish
warms107726853war__ms
warning113717093warning
warpage1336403warpage
warping133715183warping
warpwise1642853warpwise
warring113717973warring
warrior1045363warrior
warsle93112923war_sle
warstle10328013warstle
wart77866083wart___
warted104223233wart_ed
warthog1444533warthog
wartiest113614643wartiest
warts814840403wart__s
warty119323823wart__y
wastage11109253wastage
waste86125053wast__e
wasting114422843wasting
wastrie101210293wastrie
watape11208483wa_tape
wattage1186983wattage
wattape12135383wattape
wattle94314213wa_ttle
waxlike21185973waxlike
wayside1435183wayside
write85522833w_r_ite
writhe125310703w_rithe
wurtzite2042003wurtzite
zaratite1747793zaratite

Search took 10 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.1531167915.0
2DLD Change Limit1340272078.87615099.9
3Display Results2072070.0762723.7
 (SQL Overall)1786912079.10519625.6
 
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.